appointment
Tables (5)
appointment (Untitled3)
- id (예약아이디) — INT — Primary key — NOT NULL
- user_id (회원아이디) — INT — Foreign key → user.id — NOT NULL
- store_id (매장아이디) — INT — Foreign key → store.id — NOT NULL
- user_name (회원이름) — VARCHAR(50)
- store_name (매장이름) — VARCHAR(50)
- visited (방문여부) — TINYINT(1)
- regi_date (예약한시간) — DATETIME(6)
review (Untitled4)
- id (리뷰아이디) — INT — Primary key — NOT NULL
- appointment_id (예약아이디) — INT — Foreign key → appointment.id — NOT NULL
- review (리뷰) — TEXT
store (Untitled2)
- id (매장아이디) — INT — Primary key — NOT NULL
- store_name (매장이름) — VARCHAR(50)
- store_position (매장위치) — TEXT
- store_description (매장설명) — TEXT
user (Untitled)
- id (회원아이디) — INT — Primary key — NOT NULL
- user_name (회원이름) — VARCHAR(50)
- password (비밀번호) — VARCHAR(100)
user_roles (CopyOfUntitled)
- user_id (회원아이디) — INT — Foreign key → user.id — NOT NULL
- roles (역활) — VARCHAR(50)