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)