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