myself

Tables (6)

FOOD (Untitled2)

  • FD_NAME (Field3) — VARCHAR2(20) — Primary key
  • FD_TYPE (Field) — VARCHAR2(20)
  • FD_PRICE (Field2) — NUMBER(10)

MEMBER (Untitled)

  • MEM_ID (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • MEM_NAME (Field) — VARCHAR2(10)
  • MEM_PASS (Field2) — NUMBER(50)
  • MEM_MILEAGE (Field3) — NUMBER(10)
  • MEM_PHONE (Field4) — VARCHAR2(20)

PAY (Untitled4)

  • FD_NAME (Field32) — VARCHAR2(20) — Foreign key → FOOD.FD_NAME
  • PAY_DAY (Field) — DATE
  • PRICE (Field2) — NUMBER(10)
  • PAY_AMOUNT (Field3) — NUMBER(10)
  • MEM_ID (Key2) — VARCHAR2(10) — Foreign key → MEMBER.MEM_ID — NOT NULL

PROD (Untitled6)

  • FD_NAME (Field3) — VARCHAR2(20) — Foreign key → FOOD.FD_NAME
  • COST (Field) — NUMBER(10)
  • PRICE (Field2) — NUMBER(10)

SALES (Untitled5)

  • SA_MONTH (Field) — DATE
  • TOTAL_PRICE (Field2) — NUMBER(10)
  • FEE (Field3) — NUMBER(10)
  • INCOME (Field4) — NUMBER(10)

STOCK (Untitled3)

  • FD_NAME (Field32) — VARCHAR2(20) — Foreign key → FOOD.FD_NAME
  • I_STOCK (Field) — NUMBER(10)
  • OUT_STOCK (Field2) — NUMBER(10)
  • CUR_STOCK (Field3) — NUMBER(10)