배달의민족
테이블 (10)
address_tbl
- addressCode — INT
- userCode — INT
- deliveryAddress — VARCHAR(200) — NOT NULL
- detailDeliveryAddress — varchar(300) — NOT NULL
- addressStatus — int — NOT NULL
cart_tbl
- cartCode — int
- userId — varchar(30)
- storeCode — int
- menuCode — int
- optionCode — int
- menuCount — int
- cartPrice — int
- optionStatus — tinyint
menu_tbl
- menuCode — INT
- storeCode — INT
- menuName — VARCHAR(50) — NOT NULL
- menuPrice — INT
- menuImage — VARCHAR(50)
- menuContent — TEXT — NOT NULL
- menuClassification — VARCHAR(50)
- menuStatus — TINYINT — NOT NULL
option_tbl
- optionCode — int
- menuCode — int
- optionCategory — varchar(255)
- optionSelectType — tinyint
- optionName — varchar(255)
- optionPrice — int
- optionStatus — INT
order_tbl
- orderNumber — INT
- menuCode — int
- userCode — int
- storeCode — int
- orderMenuName — varchar(100)
- orderMenuNumber — int
- orderMenuPrice — int
- orderStoreName — varchar(100)
- orderStoreImage — varchar(100)
- orderDate — DATE
- payType — TINYINT(1)
- orderType — TINYINT(1)
- reqToSeller — VARCHAR(300)
- reqToRider — VARCHAR(300)
- orderStatus — VARCHAR(200)
- optionsInfo — varchar(300)
- deliveryFee — INT
- deliveryAddress — VARCHAR(200)
- userPhone — varchar(50)
- reviewStatus — TINYINT(1)
review_tbl
- reviewCode — INT
- orderMenuName — VARCHAR(100)
- userCode — int
- storeCode — int
- orderNumber — int
- reviewImage — VARCHAR(300)
- reviewDate — DATE
- reviewRating — INT
- reviewContent — VARCHAR(300)
- reviewImageName — VARCHAR(300)
- userNickName — VARCHAR(100)
- answerContent — VARCHAR(300)
- answerDate — DATE
seller_tbl
- sellerCode — INT
- sellerRegCode — VARCHAR(30) — NOT NULL
- sellerId — VARCHAR(20) — NOT NULL
- sellerPw — VARCHAR(30) — NOT NULL
- sellerName — VARCHAR(20) — NOT NULL
- sellerPhone — VARCHAR(50) — NOT NULL
- sellerEmail — VARCHAR(50) — NOT NULL
- sellerBirth — VARCHAR(20) — NOT NULL
- sellerGender — TINYINT(1) — NOT NULL
- sellerStatus — TINYINT(1) — NOT NULL
store_tbl
- storeCode — INT
- sellerCode — int
- storeName — VARCHAR(50) — NOT NULL
- storeCategory — VARCHAR(50) — NOT NULL
- storeImage — VARCHAR(200)
- storeAddress — VARCHAR(200)
- storeAddressDetail — VARCHAR(200)
- storePhone — VARCHAR(12) — NOT NULL
- zzimCount — INT
- reviewCount — INT
- storeRating — DECIMAL(3, 1)
- storeDescription — VARCHAR(1000)
- minOrderPrice — INT — NOT NULL
- deliveryFee — INT — NOT NULL
- operatingTime — VARCHAR(50)
- deliveryArea — VARCHAR(50) — NOT NULL
- storeStatus — INT
user_tbl
- userCode — INT
- userId — VARCHAR(20)
- userPw — VARCHAR(30)
- userName — VARCHAR(20)
- userNickname — VARCHAR(20)
- userPhone — VARCHAR(50)
- userEmail — VARCHAR(50)
- userBirth — VARCHAR(20)
- userGender — TINYINT(1)
- userPostCode — VARCHAR(50)
- userAddress — VARCHAR(150)
- userAddressDetail — VARCHAR(150)
- userStatus — TINYINT(1) — NOT NULL
zzim_tbl
- userCode — int
- storeCode — int