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)