erd
Tables (10)
hotels (호텔)
- hotel_id (pk) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(100)
pointHistory (포인트이력)
- pointHistory_id (Key) — BIGINT — Primary key — NOT NULL
- pointType_id (Key2) — BiGINT — Foreign key → pointType.pointType — NOT NULL
- accumulate_point (Field2) — BIGINT
- is_Add (Field3) — tinyint(1)
pointType (포인트타입)
- pointType (Key) — BiGINT — Primary key — NOT NULL
- type (Field) — varchar(100)
pointrule (포인트룰)
- pointrule_id (Key) — BIGINT — Primary key — NOT NULL
- pointType_id (Key2) — BiGINT — Foreign key → pointType.pointType — NOT NULL
- point (Field2) — BIGINT
reservation (예약)
- reservation_id (Field2) — Primary key
- room_id (pk) — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id (pk2) — BIGINT — Foreign key → user.user_id — NOT NULL
- cnt (Field3) — INT
- in_date (Field4) — datetime
- out_date (Field5) — date
- Field6
review (리뷰)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (fk) — BIGINT — Foreign key → user.user_id — NOT NULL
- room_id (pk2) — BIGINT — Foreign key → rooms.room_id — NOT NULL
- content (Field) — text
- is_blind (Field2) — tinyint(1)
reviewImage (리뷰이미지)
- reviewImage_id (Key) — BIGINT — Primary key — NOT NULL
- image_url (Field) — text
- review_id (fk) — BIGINT — Foreign key → review.review_id — NOT NULL
roomImage (방이미지)
- roomImage_id (Key) — BIGINT — Primary key — NOT NULL
- image_url (Field) — text
rooms (방)
- room_id (pk) — BIGINT — Primary key — NOT NULL
- hotel_id (fk) — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- name (Field) — varchar(100)
- capacity (Field2) — tinyint
- floor (Field3) — tinyint
- bathtub_flag (Field4) — tinyint(1)
- view_type (Field5) — tinyint
- created_at (Field6) — DATETIME
user (Untitled3)
- user_id (pk) — BIGINT — Primary key — NOT NULL
- username (Field) — varchar(100)
- password (Field2) — varchar(100)
- point (Field3) — BIGINT