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