0514
Tables (9)
Untitled4 (prodTBL)
- Key (prodName) — VARCHAR(45) — Primary key — NOT NULL
- Field (price) — INT — NOT NULL
- Field2 (company) — VARCHAR(45)
Untitled4 (buyTBL)
- Key (username) — VARCHAR(3) — Foreign key → prodTBL.Key — NOT NULL
- Key (prodName) — VARCHAR(45) — Foreign key → Untitled4.Key — NOT NULL
- Field (amount) — INT — NOT NULL
buyTBL (Untitled3)
- username (VARCHAR(3)) — VARCHAR(3) — Foreign key → userTBL.username — NOT NULL
- prodTBL (VARCHAR(45)) — VARCHAR(45) — Foreign key → prodTBL.prodTBL — NOT NULL
- amount (INT) — INT — NOT NULL
buyTBL (Untitled6)
- 고객이름 (Key) — VARCHAR(3) — Foreign key → userTBL.고객이름 — NOT NULL
- 구매 제품명 (Key2) — VARCHAR(45) — Foreign key → prodTBL.제품명 — NOT NULL
- 수량 (Field) — INT — NOT NULL
prodTBL (Untitled2)
- prodTBL (VARCHAR(45)) — VARCHAR(45) — Primary key — NOT NULL
- price (INT) — INT — NOT NULL
- company (VARCHAR(40)) — VARCHAR(45)
prodTBL (userTBL)
- Key (username) — VARCHAR(3) — Primary key — NOT NULL
- Field (birthYear) — INT — NOT NULL
- Field2 (addr) — VARCHAR(45) — NOT NULL
- Field3 (mobile) — VARCHAR(12)
prodTBL (Untitled5)
- 제품명 (Key) — VARCHAR(45) — Primary key — NOT NULL
- 단가 (Field) — INT — NOT NULL
- 제조사 (Field2) — VARCHAR(45)
userTBL (Untitled)
- username (VARCHAR(3)) — VARCHAR(3) — Primary key — NOT NULL
- birthYear (INT) — INT — NOT NULL
- addr (VARCHAR(45)) — VARCHAR(45) — NOT NULL
- mobile (VARCHAR(12)) — VARCHAR(12)
userTBL (Untitled4)
- 고객이름 (Key) — VARCHAR(3) — Primary key — NOT NULL
- 출생년도 (Field) — INT — NOT NULL
- 주소 (Field2) — VARCHAR(45) — NOT NULL
- 연락처 (Field3) — VARCHAR(12)