airbnb 클론 프로젝트

테이블 (3)

Accommodation (Accomodation)

  • id (Key) — Long — 기본 키 — NOT NULL
  • userId (Key2) — Long — 외래 키 → User.id — NOT NULL
  • title (Field) — String
  • house_name (Field2) — String
  • fee (Field3) — String
  • content (Field4) — String
  • address (Field5) — String
  • people (Field6) — int
  • wifi (Field7) — boolean
  • parking (Field8) — false
  • images (Field9)
  • category (Field10) — String
  • room (Field11) — int

Comment

  • id (Key) — Long — 기본 키 — NOT NULL
  • accommodationId (Key2) — Long — 외래 키 → Accommodation.id — NOT NULL
  • comment (Field) — String
  • checkin (Field2) — int
  • clean (Field3) — int
  • accuracy (Field4) — int
  • communication (Field5) — int
  • location (Field6) — int
  • satisfaction (Field7) — int

User

  • id (Key) — Long — 기본 키 — NOT NULL
  • email (Field) — String
  • nickname (Field2) — String
  • password (Field3) — String