123
Tables (14)
CEOReviews
- reviewID — char(11) — Foreign key → Reviews.reviewID — NOT NULL
- storeID — char(12) — NOT NULL — 음식 카테고리+지역(우편번호)+가게 고유번호
- content — varchar(255) — NOT NULL
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
Carts
- basketID — bigint(20) — Primary key — NOT NULL
- storeID — char(12) — NOT NULL
- memberID — varchar(20) — NOT NULL
- menuID — char(16) — NOT NULL
- menuOptionID — char(19)
- quantity — int(3) — NOT NULL
Favorites
- storeID — char(12) — NOT NULL — 음식 카테고리+지역(우편번호)+가게 고유번호
- memberID — varchar(20) — NOT NULL
MemberAddress
- memberID — varchar(20) — Foreign key → Users.memberID — NOT NULL
- addressID — varchar(255) — NOT NULL
Menu
- menuID — char(16) — Primary key — NOT NULL — 가게ID+메뉴번호(001~999)
- storeID — char(12) — NOT NULL
- memberID — varchar(20) — NOT NULL
- category — int(3) — NOT NULL — 메인메뉴, 서브메뉴, 음료 등
- menuName — varchar(20) — NOT NULL
- menuIntro — text
- price — int(8) — NOT NULL
- menuPictureUrl — text — 사진 url
- salesStatus — int(1) — NOT NULL
MenuOption
- menuOptionID — char(19) — Primary key — NOT NULL — 메뉴ID+옵션번호(_01~_99)
- menuID — char(16) — NOT NULL
- optionName — varchar(20) — NOT NULL
- optionPrice — int(8) — NOT NULL
Payment
- paymentID — char(9) — Primary key — NOT NULL — 포장,예약,직방 구분
- basketID — bigint(20) — Foreign key → Carts.basketID — NOT NULL
- payment — int(1) — NOT NULL
- orderTime — timestamp — NOT NULL
- totalPrice — bigint(10) — NOT NULL
- orderState — int(1) — NOT NULL
- request — varchar(50)
- reservTime — timestemp
- reservInfo — varchar(255)
Points
- memberID — varchar(20) — Foreign key → Users.memberID — NOT NULL
- reviewID — bigint(20) — NOT NULL
- point — int(8) — NOT NULL
- createdDate — timestamp — NOT NULL
- expireDate — timestamp — NOT NULL
Reviews
- reviewID — char(11) — Primary key — NOT NULL
- memberID — varchar(20) — NOT NULL
- storeID — char(12) — NOT NULL
- rating — decimal(2, 1) — NOT NULL
- content — varchar(255) — NOT NULL
- reviewPictureUrl — text — 사진 url
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
Select
- memberID — varchar(20) — Foreign key → Users.memberID — NOT NULL
- storeID — char(12) — NOT NULL — (음식 카테고리)영문2자 + 사업자번호
StorePicture
- storePictureID — char(13) — Primary key — NOT NULL
- storeID — char(12) — NOT NULL
- storePictureUrl — text — NOT NULL — 사진 url
Stores
- storeID — char(12) — Primary key — NOT NULL — (음식 카테고리)영문2자 + 사업자번호
- Field — varchar(20) — NOT NULL
- name — varchar(30) — NOT NULL
- category — int(3) — 한식, 카페, 레스토랑
- zipCode — int(5) — NOT NULL — 우편번호 5자리
- address — varchar(30) — NOT NULL — 상세주소
- bankAccount — bigint(25) — NOT NULL
- rating — decimal(2, 1) — NOT NULL — 0-5.0
- dibsCount — int(6) — NOT NULL
- reviewCount — int(6) — NOT NULL
- storeCategory — int(1) — NOT NULL — 포장, 가게 운영 포장만 운영 가게만 운영
- status — int(1) — NOT NULL — 영업/휴무/폐업
- createdDate — timestamp — NOT NULL
- phone — varchar(20)
- storePicture — text — 로고 사진이 등록되었는지 여부
- logoPictureUrl — text — 가게 목록에 등장하는 로고 사진 / 사진 url
- introduction — varchar(255)
- operationHours — time
- closedDate — date
Untitled
- storeID — char(12) — Foreign key → Stores.storeID — NOT NULL — (음식 카테고리)영문2자 + 사업자번호
- Field — int(8)
- Field2 — date
Users
- memberID — varchar(20) — Primary key — NOT NULL
- password — varchar(20) — NOT NULL
- name — varchar(30) — NOT NULL
- phone — bigint(11) — NOT NULL
- birthDate — int(7) — NOT NULL — 주민번호7자리
- userStatus — int(1) — NOT NULL
- profilePic — text — 사진 url
- email — varchar(50)
- kakaoYN — int(1) — T or F