Baedal
Tables (7)
Address
- addressId — bigint(20) — NOT NULL
- userId — bigint(20) — NOT NULL
- address — varchar(255) — NOT NULL
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Menu
- menuId — bigint(20) — NOT NULL
- storeId — bigint(20) — NOT NULL
- category — varchar(100) — NOT NULL
- name — varchar(255) — NOT NULL
- price — int(11) — NOT NULL
- menuPictureUrl — text
- popularity — tinyint(1) — NOT NULL — 일반, 인기
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
MenuOption
- menuOptionId — bigint(20) — NOT NULL
- menuId — bigint(20) — NOT NULL
- option — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- price — int(11) — NOT NULL
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Rider (CopyOfCopyOfUsers)
- userId — bigint(20) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- grade — varchar(100) — NOT NULL — 고마운분, 귀한분, 더귀한분, 천생연분
- role — varchar(100) — NOT NULL
- currentAddress — varchar(255)
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Stores
- storeId — bigint(20) — NOT NULL
- name — varchar(255) — NOT NULL
- type — int(1) — NOT NULL
- category — varchar(20) — NOT NULL
- address — varchar(255) — NOT NULL
- storePictureUrl — text
- phone — varchar(20) — NOT NULL
- content — varchar(255)
- minDeliveryPrice — int(11) — NOT NULL
- deliveryTip — int(11) — NOT NULL
- minDeliveryTime — int(3)
- maxDeliveryTime — int(3)
- rating — decimal(2,1) — NOT NULL
- operationHours — varchar(255)
- closedDays — varchar(255)
- deliveryAddress — varchar(255)
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Users
- userId — bigint(20) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- grade — varchar(100) — NOT NULL — 고마운분, 귀한분, 더귀한분, 천생연분
- role — varchar(100) — NOT NULL
- currentAddress — varchar(255)
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
owner (CopyOfUsers)
- userId — bigint(20) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- grade — varchar(100) — NOT NULL — 고마운분, 귀한분, 더귀한분, 천생연분
- role — varchar(100) — NOT NULL
- currentAddress — varchar(255)
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL