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