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