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