OrderSystem

Tables (4)

Customer (Untitled3)

  • id (Key) — varchar2(10) — Primary key — NOT NULL — 고객번호
  • businessNumber (Field) — varchar2(25) — 사업자번호
  • phoneNumber (Field2) — varchar2(25) — NOT NULL — 전화번호

Item (Untitled2)

  • id (Key) — varchar2(10) — Primary key — NOT NULL — 제품번호
  • name (Field) — varchar2(25) — NOT NULL — 제품이름
  • stockQuantity (Field2) — int — NOT NULL — 재고수량

Order (Untitled)

  • id (Key) — varchar2(10) — Primary key — NOT NULL — 주문번호
  • orderDate (Field) — varchar2(25) — NOT NULL — 주문일자
  • customerId (Key2) — varchar2(25) — Foreign key → Customer.id — NOT NULL — 고객번호

OrderItem (Untitled5)

  • id (Key) — varchar2(10) — Primary key — NOT NULL
  • itemId (Key2) — varchar2(25) — Foreign key → Item.id — NOT NULL — 제품번호
  • orderId (Key3) — varchar2(100) — Foreign key → Order.id — NOT NULL — 주문번호
  • orderQuantity (Field) — NOT NULL