Cafe_Pos_V1
Tables (5)
CUSTOMER (Untitled)
- 고유번호 (Key) — NUMBER — Primary key — NOT NULL
- 고객명 (Field) — VARCHAR2 — NOT NULL
- 고객마일리지 (Field2) — NUMBER
- 일시 (Field4) — DATE
- Field5 — NUMBER
- 고객번호 (Field3) — VARCHAR2 — NOT NULL
Copy Of CUSTOMER (CopyOfUntitled)
ORDER (Untitled2)
- Key2 — NUMBER — Primary key — NOT NULL
- 고유번호 (Key) — VARCHAR2 — Foreign key → CUSTOMER.고유번호 — NOT NULL
- 주문일시 (Field) — DATE — NOT NULL
- 총주문가격 (Field2) — NUMBER — NOT NULL
- pyment_type (Field3) — VARCHAR2 — NOT NULL
ORDER_DETAIL (CopyOfUntitled2)
- Key2 — NUMBER — Foreign key → ORDER.Key2 — NOT NULL
- Field — NUMBER — NOT NULL
- Field2 — NUMBER — NOT NULL
PRODUCT (Untitled3)
- Key — NUMBER — Primary key — NOT NULL