week2

Tables (4)

recommendlist

  • id (Key) — PK — Primary key — NOT NULL
  • use_id (Key2) — FK — Foreign key → user.id — NOT NULL
  • room_id (Key3) — FK — Foreign key → room.id — NOT NULL

reservation

  • id (Key) — PK — Primary key — NOT NULL
  • use_id (Key2) — FK — Foreign key → user.id — NOT NULL
  • room_id (Key3) — FK — Foreign key → room.id — NOT NULL
  • start_date (Field) — timestamp
  • end_date (Field2) — timestamp
  • head_count (Field3) — int

room

  • id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varchar(15)
  • price (Field2) — int
  • image (Field3) — int
  • summary (Field4) — varchar(255)
  • reserved (Field5) — boolean

user

  • id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varchar(15)
  • password (Field2) — varchar(15) — NOT NULL
  • email (Field3) — varchar(255)