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