project
Tables (8)
announcement
- Key — Primary key — NOT NULL
- announcement_number (PK) — int
- hotel_number (FK) — int
- title (text) — text
- content (Field4) — text
comment (CopyOfUntitled2)
- Key — Primary key — NOT NULL
- comment_number (PK) — int
- hotel_number (FK) — int
- user_id (Field3) — int
- user_nickname (Field4) — text
- user_profile_url (Field5) — text
- write_date (Field6) — datetime
- comment_content (Field) — text
company (CopyOfUntitled)
- Key — Primary key — NOT NULL
- hotel_number (PK) — int
- hotel_name (Field2) — text
- hotel_category (Field3) — text
- hotel_rating (Field4) — int
- hotel_style (Field5) — text
- other_category (Field6) — text
- hotel_location (Field) — text
- other_category (Field7) — text
- hotel_location (Field8) — text
- hotel_introductio (Field9) — text
- hotel_main_image (Field10) — text
- hotel_grade (Field11) — double
- number_of_grade (Field12) — int
- breakfast (Field13) — int
- short_term (Field14) — int
- free_parking (Field15) — int
- free_internet (Field16) — int
- free_cancel (Field17) — int
- free_shuttle (Field18) — int
- like_count (Field19) — int
- comment_count (Field20) — int
facilities (CopyOfCopyOfUntitled)
- Key — Primary key — NOT NULL
- hotel_number (PK) — int
- golf (Field2) — int
- airport_shuttle (Field3) — int
- non_smoking_room (Field4) — int
- restuant (Field5) — int
- rooptop (Field6) — int
- pet_allowed (Field) — int
- business_center (Field7) — int
- adult_only (Field8) — int
- swimming_pool (Field9) — int
- spa (Field10) — int
- air_conditioner (Field11) — int
- elevator (Field12) — int
- hot_tub (Field13) — int
- wi_fi (Field14) — int
- disabled_visitor (Field15) — int
- electric_charging_station (Field16) — int
- parking (Field17) — int
- casino (Field18) — int
- front_desk_service (Field19) — int
- fitness (Field20) — int
- beach (Field21) — int
- hair_dryer (Field22) — int
- kitchen (Field23) — int
liky (CopyOfCopyOfUntitled2)
- Key — Primary key — NOT NULL
- hotel_number (PK) — int
- user_id (FK) — int
- user_nickname (Field4) — text
- user_profile_url (Field5) — text
room
- Key — Primary key — NOT NULL
- hotel_number (PK) — int
- hotel_number (Field2) — int
- room_name (Field3) — text
- number_of_people (Field4) — int
- bed_size (Field5) — text
- number_of_bed (Field6) — int
- area (Field) — text
searchwordlog (CopyOfUntitled3)
- Key — Primary key — NOT NULL
- sequence (PK) — int
- search_word (Field2) — text
user (Untitled)
- Key — Primary key — NOT NULL
- id (PK) — int
- email (Field2) — varchar(45)
- password (Field3) — varchar(225)
- nickname (Field4) — varchar(225)
- profile (Field5) — text
- address (Field6) — text