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