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)