minjok of delivery
Tables (6)
admin (Untitled6)
- adminid (Key) — varchar(300) — Primary key — NOT NULL
- mainevent (메인이벤트) — varchar(1000)
- Field
customer (Untitled)
- custid (Key) — varchar(300) — Primary key — NOT NULL
- custpw (고객비밀번호) — varchar(300)
- custname (고객이름) — varchar(300)
- custnick (닉네임) — varchar(300)
- custbirth (고객생일) — varchar(300)
- custphone (고객폰번호) — varchar(300)
- custgender (고객성별) — varchar(3)
- custzipcode (고객우편함주소) — varchar(300)
- custaddr (고객주소) — varchar(1000)
- custaddrdetail (고객상세주소) — varchar(1000)
- custaddretc (고객주소특이사항) — varchar(300)
- custimg (고객프로필사진) — varchar(1000)
- custcp (고객소유쿠폰) — varchar(1000)
- custvip (고객등급) — varchar(300)
- custcp (고객쿠폰) — varchar(1000)
delivery_driver (Untitled2)
- drid (Key) — bigint — Primary key — NOT NULL
- oderid (Key2) — bigint — Foreign key → oderlist.oderid — NOT NULL
- custid (Key22) — varchar(300) — Foreign key → oderlist.custid — NOT NULL
- menuid (Key3) — bigint — Foreign key → oderlist.menuid — NOT NULL
- storeid (Key222) — varchar(300) — Foreign key → oderlist.storeid — NOT NULL
menu (Untitled4)
- menuid (Key) — bigint — Primary key — NOT NULL
- storeid (Key2) — varchar(300) — Foreign key → store.storeid — NOT NULL
- menudistintion (메뉴구분) — varchar(300)
- menuname (메뉴이름) — varchar(300)
- menuprice (메뉴가격) — int
- menuorigin (원산지표시) — varchar(3000)
oderlist (Untitled5)
- oderid (Key) — bigint — Primary key — NOT NULL
- custid (Key2) — varchar(300) — Foreign key → customer.custid — NOT NULL
- menuid (Key3) — bigint — Foreign key → menu.menuid — NOT NULL
- storeid (Key22) — varchar(300) — Foreign key → menu.storeid — NOT NULL
- Field
store (Untitled3)
- storeid (Key) — varchar(300) — Primary key — NOT NULL
- storename (가게이름) — varchar(300)
- storephone (가게번호) — varchar(300)
- storeaddr (가게주소) — varchar(1000)
- storenum (사업자번호) — varchar(300)
- storedistintion (가게구분) — varchar(300)
- storecp (가게쿠폰) — varchar(1000)