danjam
Tables (13)
amenity (편의시설)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (편의시설명) — VARCHAR(50)
booking (예약)
- id (아이디) — BIGINT — Primary key — NOT NULL
- person (이용 인원 수) — INT
- check_in (체크인 날짜) — TIMESTAMP
- check_out (체크아웃 날짜) — TIMESTAMP
- user_id (사용자 id) — BIGINT — Foreign key → users.id — NOT NULL
- room_id (방 id) — BIGINT — Foreign key → room.id — NOT NULL
- id (아이디2) — BIGINT — Foreign key → payment.id — NOT NULL
d_amenity (숙소편의시설)
- id (아이디) — BIGINT — Primary key — NOT NULL
- dorm_id (아이디3) — BIGINT — Foreign key → dorm.id — NOT NULL
- amenity_id (아이디2) — BIGINT — Foreign key → amenity.id — NOT NULL
d_category (숙소 유형)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (숙소 유형) — VARCHAR(45)
dorm (숙소)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (숙소명) — VARCHAR(100)
- desciption (숙소 설명) — LONGTEXT
- contact_num (연락처) — VARCHAR(13)
- city (도/시) — VARCHAR(10)
- town (시/군/구) — VARCHAR(10)
- address (주소) — VARCHAR(255)
- status (예약 가능 여부) — CHAR(1)
- seller_id (판매자 id) — BIGINT — Foreign key → users.id — NOT NULL
- category_id (숙소유형 id) — BIGINT — Foreign key → d_category.id — NOT NULL
payment (결제 내역)
- id (아이디) — BIGINT — Primary key — NOT NULL
- payment_key (결제 key) — VARCHAR(200)
- order_id (주문 id) — VARCHAR(64)
- total_amount (전체 결제 금액) — INT
- approved_at (Field) — TIMESTAMP
- status (Field2) — VARCHAR(45)
- user_id (구매자 id) — BIGINT — Foreign key → users.id — NOT NULL
r_tag (Untitled)
- id (아이디) — BIGINT — Primary key — NOT NULL
- tag_id (해시태그 id) — BIGINT — Foreign key → tag.id — NOT NULL
- review_id (후기 id) — BIGINT — Foreign key → review.id — NOT NULL
review (사용 후기)
- id (아이디) — BIGINT — Primary key — NOT NULL
- content (내용) — TEXT
- rate (평점) — DOUBLE
- created_at (작성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- booking_id (예약 id) — BIGINT — Foreign key → booking.id — NOT NULL
room (방)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (방 이름) — VARCHAR(100)
- description (방 설명) — TEXT
- person (수용인원) — INT
- price (가격) — INT
- type (유형) — VARCHAR(10)
- dorm_id (숙소 id) — BIGINT — Foreign key → dorm.id — NOT NULL
room_img (방 사진)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (사진 업로드명) — VARCHAR(255)
- name_original (사진 원본명) — VARCHAR(255)
- size (크기) — VARCHAR(45)
- ext (확장자) — VARCHAR(10)
- room_id (방 id) — BIGINT — Foreign key → room.id — NOT NULL
tag (해시태그)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (태그명) — VARCHAR(30)
- PN (positive, negative) — CHAR(1)
users (사용자)
- id (아이디) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(30)
- password (비밀번호) — VARCHAR(100)
- name (이름) — VARCHAR(45)
- phone_number (핸드폰번호) — VARCHAR(11)
- role (권한) — ENUM(ROLE_ADMIN, ROLE_SELLER, ROLE_USER)
- created_at (가입일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
wish (찜)
- id (아이디) — BIGINT — Primary key — NOT NULL
- created_at (찜 생성일자) — TIMESTAMP
- dorm_id (숙소 id) — BIGINT — Foreign key → dorm.id — NOT NULL
- user_id (사용자 id) — BIGINT — Foreign key → users.id — NOT NULL