boostcamp2

Tables (3)

Accomodation

  • akey — INT — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • price — INT — NOT NULL
  • people — INT — NOT NULL
  • latitude — float — NOT NULL
  • longitude — float — NOT NULL

reserved_days

  • rdkeyr (rdkey) — INT — Primary key — NOT NULL — auto_increment
  • akey — INT — Foreign key → Accomodation.akey — NOT NULL
  • reserved_day — DATE

review

  • rkey — INT — Primary key — NOT NULL — auto_increment
  • akey — INT — Foreign key → Accomodation.akey — NOT NULL
  • point — FLOAT
  • review — LONG