옷제작판매

테이블 (7)

clothTBL

  • clothid (key) — not null — 기본 키 — NOT NULL
  • groupname (name) — null
  • color — not null
  • clothsize (size) — not null
  • price — not null
  • count — null

companyTBL

  • rownumb (Key) — default — 기본 키 — NOT NULL
  • clothid (key2) — not null — 외래 키 → clothTBL.clothid — NOT NULL
  • orderid (key3) — not null — 외래 키 → orderTBL.orderid — NOT NULL
  • cpstoreid (key4) — not null — 외래 키 → cpstoreTBL.cpstoreid — NOT NULL
  • amount — not null
  • warehousing — not null
  • bereleased — not null

cpstoreTBL

  • cpstoreid (key) — not null — 기본 키 — NOT NULL
  • storename (name) — not null
  • storeaddress (address) — null
  • storehp (hp) — null

orderTBL

  • orderid (key) — not null — 기본 키 — NOT NULL
  • clothid (key2) — not null — 외래 키 → clothTBL.clothid — NOT NULL
  • userid (Key3) — not null — 외래 키 → userTBL.userid — NOT NULL
  • count (counti) — null
  • price — null

shopTBL

  • rownumber (Key) — default — 기본 키 — NOT NULL
  • cpstoreid (key2) — not null — 외래 키 → cpstoreTBL.cpstoreid — NOT NULL
  • clothid (key3) — not null — 외래 키 → clothTBL.clothid — NOT NULL
  • shopname (name) — not null
  • amount — not null
  • warehousing — not null
  • bereleased — not null

totalpriceTBL

  • totalinAmount (inAmount) — null
  • totalinprice (inprice) — not null
  • totaloutAmount (outAmount) — null
  • totaloutprice (outprice) — not null
  • totalremainAmount (remainAmount) — null
  • totalremainprice (remainprice) — not null

userTBL

  • userid (Key) — not null — 기본 키 — NOT NULL
  • username (name) — not null
  • addr — null
  • mobile (number) — null