프로젝트

테이블 (7)

card

  • cardNum — varchar(300) — 기본 키 — NOT NULL
  • userid — varchar(300) — 외래 키 → user.Key — NOT NULL
  • Field (cardNick) — varchar(300)
  • Field (cardCom) — varchar(300)
  • Field (cardpw) — varchar(300)
  • Field (cardValid) — varchar(300)
  • Field (cardCVC) — int

cart (Untitled)

  • Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
  • Key (foodNum) — int — 외래 키 → food.Key — NOT NULL
  • Key (userid) — varchar(300) — 외래 키 → user.Key — NOT NULL
  • Field (foodAmount) — int

food

  • Key (foodNum) — int — 기본 키 — NOT NULL
  • Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
  • Field (foodName) — varchar(300)
  • Field (foodPrice) — int

heartlist

  • userid — varchar(300) — 외래 키 → user.Key — NOT NULL
  • Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL

orderlist

  • userid — varchar(300) — 외래 키 → user.Key — NOT NULL
  • Key (foodNum) — int — 외래 키 → food.Key — NOT NULL
  • Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
  • Field (foodAmount) — int
  • Field (orderTime) — varchar(300)

restaurant

  • Key (resNum) — int — 기본 키 — NOT NULL
  • Field (resName) — varchar(300)
  • Field (resType) — varchar(300)

user

  • Key (userid) — varchar(300) — 기본 키 — NOT NULL
  • Field (userpw) — varchar(300)
  • Field (userName) — varchar(300)
  • Field (userAge) — int
  • Field (userGender) — char(1)
  • Field (userPhone) — varchar(300)
  • Field (userAddr) — varchar(2000)
  • Field (userNick) — varchar(300)