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