Get Started. It's Free
or sign up with your email address
Rocket clouds
Hotel by Mind Map: 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. Booking

3.1. bk_id int 10 PK

3.2. bk_check_in date

3.3. bk_check_out date

3.4. bk_night int 3

3.5. bk_total_price int 7

3.6. bk_total_room int 3

3.7. bk_rm_id int 10 FK

3.8. bk_mb_id int 5 FK

3.9. bk_pay_id int 10 FK

4. Rooms

4.1. rm_id int 5 PK

4.2. rm_number var 3

4.3. rm_price int 7

4.4. rm_status var 10

4.5. rm_type var 20

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