옷제작판매
테이블 (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