tig

Tables (16)

Reservation

  • reservation_id — INT — Primary key — NOT NULL
  • user_id (user_id2) — INT — Foreign key → Users.user_id — NOT NULL
  • check_in_date — DATETIME — NOT NULL
  • check_out_date — DATETIME — NOT NULL
  • adults — INT — NOT NULL
  • childeren — INT — NOT NULL
  • infants — INT — NOT NULL
  • pets — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — cancled, exist
  • user_id — INT — NOT NULL
  • room_id — INT — NOT NULL

Reviews

  • review_id — INT — Primary key — NOT NULL
  • room_id (room_id2) — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id (user_id2) — INT — Foreign key → leisure.user_id — NOT NULL
  • text — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist, updated
  • user_id — INT — NOT NULL
  • room_id — INT — NOT NULL

Users

  • user_id — INT — Primary key — NOT NULL
  • user_name — VARCHAR(20)
  • user_sex — INT — 0: MAN, 1: WOMAN
  • user_email — VARCHAR(50)
  • user_birth — DATE
  • user_password — VARCHAR(200) — NOT NULL — 암호화 시 길어질 수 있기 때문에 200자
  • user_phone_number — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — superhost,host, user, withdrawal

Wishelists

  • wishes_id — INT — Primary key — NOT NULL
  • user_id (user_id2) — INT — Foreign key → Users.user_id — NOT NULL
  • wishes_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist
  • user_id — INT — NOT NULL

categories

  • category_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id — INT — Foreign key → leisure.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

conveniences

  • amenities_id — INT — Primary key — NOT NULL
  • amenities_name — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

leisure (Rooms)

  • room_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • room_name — VARCHAR(50) — NOT NULL
  • room_address — VARCHAR(100) — NOT NULL
  • room_latitude — VARCHAR(100) — NOT NULL
  • room_longitude — VARCHAR(100) — NOT NULL
  • room_price — INT — NOT NULL — 1박 당 가격
  • room_wishes — INT — NOT NULL — 1: 위시리스트에 추가
  • service_commission — INT — NOT NULL
  • tax — _of_lodge` — NOT NULL
  • clean_up_cost — INT — NOT NULL
  • room_description — TEXT — NOT NULL
  • check_in_time — TIME — NOT NULL
  • check_out_time — TIME — NOT NULL
  • return_policy — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — available, disavailable
  • category_id — INT — NOT NULL
  • host_id — INT — NOT NULL
  • room_types_id — INT — NOT NULL
  • location_id — INT — NOT NULL
  • room_option_id — INT — NOT NULL

leisure_images (room_images)

  • room_id — INT — Primary key — NOT NULL
  • room_id (room_id2) — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id — INT — Foreign key → leisure.user_id — NOT NULL
  • image_name — VARCHAR(200) — NOT NULL
  • path — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

leisure_service (room_options)

  • room_option_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id — INT — Foreign key → leisure.user_id — NOT NULL
  • item1 — INT — NOT NULL — 숙소의 침실 개수
  • item2 — INT — NOT NULL — 숙소의 침대 개수
  • itme3 — INT — NOT NULL — 숙소의 화장실 수
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

location

  • location_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id — INT — Foreign key → leisure.user_id — NOT NULL
  • location_name — VARCHAR(100) — NOT NULL
  • description_location — TEXT — NOT NULL
  • description_traffic — TEXT — NOT NULL

property

  • property_id — INT — Primary key — NOT NULL
  • property_middle_id — INT — Foreign key → property_middle_table.property_middle_id — NOT NULL
  • room_id (room_id2) — INT — Foreign key → property_middle_table.room_id — NOT NULL
  • user_id — INT — Foreign key → property_middle_table.user_id — NOT NULL
  • property_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

property_middle_table

  • property_middle_id — INT — Primary key — NOT NULL
  • room_id (room_id2) — INT — Foreign key → leisure.room_id — NOT NULL
  • user_id — INT — Foreign key → leisure.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — deleete, exist
  • property_id — INT — NOT NULL
  • room_id — INT — NOT NULL

room_amenities

  • room_amenities_id — INT — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist
  • amenities_id — INT — NOT NULL
  • room_id — INT — NOT NULL

room_types

  • room_types_id — INT — Primary key — NOT NULL
  • types_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updtaed_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist

user_profile

  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • image_name — VARCHAR(50) — NOT NULL
  • path — TEXT — NOT NULL
  • introduction_text — TEXT — 소개글
  • location — TEXT — 위치
  • language — VARCHAR(100) — 사용 언어
  • job — TEXT — 직장
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — confirmation, unconfirmation

wishes_middle

  • wishes_middle_id — VARCHAR(255) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • status — TEXT — NOT NULL — delete, exist
  • room_id — INT — NOT NULL
  • wishes_id — INT — NOT NULL