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)