aa

테이블 (13)

Untitled (Store)

  • Key (storeIdx) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(30) — NOT NULL
  • Field (profileImgUrl) — text
  • Field (intro) — varchar(50)
  • Field (phoneNum) — varchar(20) — NOT NULL
  • Field (ownerName) — varchar(30) — NOT NULL
  • Field (registrationNum) — varchar(10) — NOT NULL
  • Field (adress) — varchar(80) — NOT NULL
  • Field (businessHour) — varchar(30) — NOT NULL
  • Field (minOrderPrice) — int — NOT NULL
  • Field (deliveryPrice) — int — NOT NULL
  • Field (deliveryTime) — varchar(10) — NOT NULL
  • Field (ClosedDay) — varchar(20) — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Key (storeIdx2) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Menu)

  • Key (menuIdx) — int — 기본 키 — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(30) — NOT NULL
  • Field (menuImgUrl) — text
  • Field (price) — int — NOT NULL
  • Field (intro) — varchar(50)
  • Field (isRepresent) — char(1) — NOT NULL
  • Field (isAdult) — char(1) — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Review)

  • Key (reviewIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (rating) — int — NOT NULL
  • Field (reviewImgUrl) — text
  • Field (reviewText) — varchar(100) — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Order)

  • Key (orderIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (cartIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (request) — varchar(50)
  • Field (payment) — varchar(30) — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Cart)

  • Key (cartIdx) — int — 기본 키 — NOT NULL
  • Key (menuIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (num) — int — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Category)

  • Key (categoryIdx) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (categoryImgUrl) — text — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Favorite)

  • Key (favoriteIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (Coupon)

  • Key (couponIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key
  • Field (name) — varchar(20) — NOT NULL
  • Field (price) — int — NOT NULL
  • Field (valDate) — timestamp — NOT NULL
  • Field (startDate) — timestamp — NOT NULL
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

Untitled (ChatUser)

  • Key (chatUIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (roomIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(150) — NOT NULL

Untitled (Room)

  • Key (roomIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (chatStore)

  • Key (chatSIdx) — int — 기본 키 — NOT NULL
  • Key (storeIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (roomIdx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(150) — NOT NULL

Untitled2 (Point)

  • Key (pointIdx) — int — 기본 키 — NOT NULL
  • Key (userIdx) — int — 외래 키 → 사용자.Key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field (usage) — int — NOT NULL
  • Field (until) — timestamp
  • Field (createAt) — timestamp — NOT NULL
  • Field (updateAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL

사용자 (User)

  • Key (userIdx) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field2 (profileImgUrl) — text
  • Field (email) — varchar(30) — NOT NULL
  • Field (pwd) — varchar(20) — NOT NULL
  • Field (phoneNum) — varchar(11) — NOT NULL
  • Field (adress) — varchar( 80) — NOT NULL
  • Field (level) — int — NOT NULL
  • Field (mailAgree) — char(1) — NOT NULL
  • Field (smsAgree) — char(1) — NOT NULL
  • Field (createdAt) — tiemstamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL
  • Field (status) — varchar(10) — NOT NULL