tripgo1
Tables (19)
AA (Untitled7)
- id (PK) — INT — Primary key — NOT NULL
- accommodation_id (FK1) — INT — Foreign key → Accommodation.id — NOT NULL
- amenity_id (FK2) — INT — Foreign key → Amenity.id — NOT NULL
Accommodation (숙박시설)
- id (PK) — INT — Primary key — NOT NULL
- host_id (FK) — INT — Foreign key → User.id — NOT NULL
- name (Field) — VARCHAR
- phone_number (Field6) — VARCHAR
- description (Field4) — VARCHAR
- rules (Field7) — VARCHAR
- average_rating (Field3) — DOUBLE
- is_active (Field8) — BOOLEAN
- created_at (Field5) — TIMESTAMP
- updated_at (Field9) — TIMESTAMP
Accommodation_image (숙박이미지)
- id (PK) — INT — Primary key — NOT NULL
- accommodation_id (FK) — INT — Foreign key → Accommodation.host_id — NOT NULL
- image (Field) — VARCHAR
Amenity (부대시설)
- id (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- description (Field2) — VARCHAR
- icon (Field3) — VARCHAR
- category (Field4) — ENUM
- is_customized (Field5) — BOOLEAN
Booking (예약)
- id (PK) — INT — Primary key — NOT NULL
- guest_id (FK1) — INT — Foreign key → User.id — NOT NULL
- room_id (FK2) — INT — Foreign key → Room.id — NOT NULL
- check_in_date (Field) — DATE
- check_out_date (Field2) — DATE
- total_price (Field3) — INT
- status (Field4) — ENUM
- request (Field5) — VARCHAR
BusinessUser (사업자등록)
- id (PK) — INT — Primary key — NOT NULL
- host_id (FK) — INT — Foreign key → User.id — NOT NULL
- Business_number (Field) — INT
- business_document (Field4) — VARCHAR
- business_email (Field5) — VARCHAR
- business_phonenumber (Field6) — VARCHAR
- business_address (Field7) — VARCHAR
- verfied_at (Field3) — TIMESTAMP
- verification_status (Field2) — ENUM
GPS Info (위치정보)
- id (PK) — INT — Primary key — NOT NULL
- accommodation_id (FK) — INT — Foreign key → Accommodation.host_id — NOT NULL
- city (Field) — VARCHAR
- states (Field2) — VARCHAR
- road_name (Field3) — VARCHAR
- address (Field5) — VARCHAR
- latitude&longitude (Field4) — VARCHAR
Option (방 옵션)
- id (PK1) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- category (Field2) — ENUM
- is_customized (Field3) — BOOLEAN
Rating (별점)
- id (PK) — INT — Primary key — NOT NULL
- review_id (FK1) — INT — Foreign key → Review.id — NOT NULL
- rating (Field) — ENUM
Review (후기)
- id (PK) — INT — Primary key — NOT NULL
- guest_id (FK1) — INT — Foreign key → User.id — NOT NULL
- Accommodation_id (FK2) — INT — Foreign key → Accommodation.id — NOT NULL
- contents (Field) — VARCHAR
- created_at (Field2) — TIMESTAMP
- Field3
Room (방)
- id (PK) — INT — Primary key — NOT NULL
- accommodation_id (FK) — INT — Foreign key → Accommodation.host_id — NOT NULL
- name (Field) — VARCHAR
- capacity (Field2) — INT
- max_capacity (Field8) — INT
- price (Field3) — INT
- stay_type (Field9) — BOOLEAN
- description (Field4) — VARCHAR
- check_in_time (Field6) — DATETIME
- check_out_time (Field7) — DATETIME
- is_avaliable (Field5) — BOOLEAN
RoomInventory (방 갯수)
- id (PK) — INT — Primary key — NOT NULL
- room_id (FK) — INT — Foreign key → Room.id — NOT NULL
- count_room (Field2) — INT
Room_Image (방 이미지)
- id (PK) — INT — Primary key — NOT NULL
- room_id (FK) — INT — Foreign key → Room.accommodation_id — NOT NULL
- image (Field) — VARCHAR
User (사용자)
- id (PK) — INT — Primary key — NOT NULL
- first_name (Field) — VARCHAR
- last_name (Field6) — VARCHAR
- email (Field3) — VARCHAR
- password_hash (Field2) — VARCHAR
- phone_number (Field9) — VARCHAR
- gender (Field8) — ENUM
- birth_date (Field7) — DATE
- user_image (Field16) — VARCHAR
- user_type (Field4) — ENUM
- Social_id (Field10) — VARCHAR
- Social_login (Field11) — ENUM
- verified_email (Field15) — BOOLEAN
- is_active (Field12) — BOOLEAN
- created_at (Field5) — TIMESTAMP
- updated_at (Field13) — TIMESTAMP
- last_login (Field14) — TIMESTAMP
WithdrawManager (탈퇴관리)
- id (PK) — INT — Primary key — NOT NULL
- user_id (FK) — INT — Foreign key → User.id — NOT NULL
- withdraw_date (Field) — TIMESTAMP
- withdraw_reason (Field2) — VARCHAR
accommodation_type (숙박시설 종류)
- id (PK) — INT — Primary key — NOT NULL
- accommodation_id (FK) — INT — Foreign key → Accommodation.id — NOT NULL
- is_customized (Field) — BOOLEAN
- type_name (Field2) — VARCHAR
bookmark (즐겨찾기)
- user_id (PK) — INT — Foreign key → User.id — NOT NULL
- accommodation_id (FK) — INT — Foreign key → Room.accommodation_id — NOT NULL
room_type (방 타입)
- id (PK) — INT — Primary key — NOT NULL
- room_id (FK) — INT — Foreign key → Room.id — NOT NULL
- is_customized (Field) — BOOLEAN
- type_name (Field2) — VARCHAR
roomoption (Untitled5)
- Key — Primary key — NOT NULL
- accommodation_id (FK1) — INT — Foreign key → Room.accommodation_id — NOT NULL
- option_id (FK2) — INT — Foreign key → Option.id — NOT NULL