테이블링
테이블 (6)
Copy Of Copy Of STORE (managers)
- ID (id) — bigint — 기본 키 — NOT NULL
- 상점명 (email) — varchar — NOT NULL
- Field (password) — varchar — NOT NULL
- 설명 (nickname) — varchar
- 전화번호 (phone) — varchar — NOT NULL
- 오픈시간 (login_type) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime
Copy Of RESERVATION (reviews)
- ID (id) — bigint — 기본 키 — NOT NULL
- Field (rating) — double — NOT NULL
- Field (comment) — varchar
- Field (created_at) — datetime — NOT NULL
Copy Of STORE (members)
- ID (id) — bigint — 기본 키 — NOT NULL
- 상점명 (email) — varchar — NOT NULL
- Field (password) — varchar — NOT NULL
- 설명 (nickname) — varchar
- 전화번호 (phone) — varchar — NOT NULL
- 오픈시간 (login_type) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime
RESERVATION (tabling)
- ID (id) — bigint — 기본 키 — NOT NULL
- Field (time) — time — NOT NULL
- Field2 (created_at) — datetime — NOT NULL
STORE (restaurants)
- ID (id) — bigint — 기본 키 — NOT NULL
- Field (manager_id) — bigint — NOT NULL
- 상점명 (store_name) — varchar — NOT NULL
- Field (status) — varchar — NOT NULL
- 전화번호 (phone) — varchar — NOT NULL
- 주소 (address) — json
- 설명 (description) — varchar
- Field (rating) — double — NOT NULL
- 오픈시간 (open_at) — time
- 마감시간 (close_at) — time
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime
Untitled (alarm)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (alarm_type) — varchar — NOT NULL
- Field (message) — varchar — NOT NULL
- Field (read_at) — datetime
- Field (created_at) — datetime — NOT NULL