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