Hotel

1. Member

1.1. mb_id int 5 PK

1.2. mb_user var 12

1.3. mb_pass var 12

1.4. mb_firstname var 50

1.5. mb_lastname var 50

1.6. mb_email var 30

1.7. mb_tel var 10

2. News

2.1. news_id int 5 PK

2.2. news_title var 100

2.3. news_content var 255

3. Rooms

3.1. rm_id int 5 PK

3.2. rm_number var 3

3.3. rm_price int 7

3.4. rm_status var 10

3.5. rm_type var 20

4. Booking

4.1. bk_id int 10 PK

4.2. bk_check_in date

4.3. bk_check_out date

4.4. bk_night int 3

4.5. bk_total_price int 7

4.6. bk_total_room int 3

4.7. bk_rm_id int 10 FK

4.8. bk_mb_id int 5 FK

4.9. bk_pay_id int 10 FK

5. Payment

5.1. pay_id int 10 PK

5.2. pay_date timestamp

5.3. pay_bank int 7

5.4. pay_bill text