ㅁㅁ
Tables (12)
category
- id — int — Primary key — NOT NULL
- category — varchar(30) — NOT NULL
coupon
- id — int — Primary key — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- period — int
- discount — int
- is_deleted — boolean — NOT NULL
favorite_store
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- created_at — datetime — NOT NULL
- is_deleted — boolean — NOT NULL
menu
- id — int — Primary key — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- menu — varchar(200) — NOT NULL
- price — int — NOT NULL
- created_at — datetime — NOT NULL
- update_at — datetime
order
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- rider_id — int — Foreign key → rider.id
- order — varchar(100) — NOT NULL
- total_price — int — NOT NULL
- order_time — datetime — NOT NULL
owner
- id — int — Primary key — NOT NULL
- owner_id — varchar(30) — NOT NULL
- owner_passwd — varchar(255) — NOT NULL
- email — varchar(30) — NOT NULL
payment
- id — int — Primary key — NOT NULL
- payment — varchar(30) — NOT NULL
review
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- order_id — int — Foreign key → order.id
- rating — int — NOT NULL
- content — varchar(200)
- created_at — datetime — NOT NULL
- update_at — datetime
rider
- id — int — Primary key — NOT NULL
- rider_id — varchar(30) — NOT NULL
- phone — varchar(20) — NOT NULL
- vehicle — varchar(30) — NOT NULL
store
- id — int — Primary key — NOT NULL
- owner_id — int — Foreign key → owner.id — NOT NULL
- category_id — int — Foreign key → category.id — NOT NULL
- payment_id — int — Foreign key → payment.id
- store_name — varchar(50) — NOT NULL
- category — varchar(30) — NOT NULL
- phone — varchar(20) — NOT NULL
- minprice — varchar(30) — NOT NULL
- reviewCount — int — NOT NULL
- operationTime — varchar(250) — NOT NULL
- closedDay — varchar(250) — NOT NULL
- information — varchar(500)
- created_at — datetime — NOT NULL
- update_at — datetime
store_payment
- id — int — Primary key — NOT NULL
- store_id — int — Foreign key → store.id — NOT NULL
- payment_id — int — Foreign key → payment.id — NOT NULL
- created_at — datetime — NOT NULL
user
- id — int — Primary key — NOT NULL
- user_id — varchar(30) — NOT NULL
- passwd — varchar(255) — NOT NULL
- email — varchar(30) — NOT NULL
- name — varchar(100) — NOT NULL
- address — varchar(100) — NOT NULL
- created_at — datetime — NOT NULL
- update_at — datetime