projectFarmT
Tables (7)
BAG (Untitled6)
- BAGID (Key) — VARCHAR2(30) — Primary key — NOT NULL
- FARMERID (Key2) — VARCHAR2(30) — Foreign key → FARMER.FARMERID — NOT NULL
- HARVESTID (Key3) — VARCHAR2(30) — Foreign key → HARVEST.HARVESTID — NOT NULL
- HARVESTCOUNT (Field3) — NUMBER(3)
BUYLIST (Untitled5)
- BUYID (Key) — VARCHAR2(6) — Primary key — NOT NULL
- FARMERID (Key2) — VARCHAR2(30) — Foreign key → FARMER.FARMERID — NOT NULL
- SEEDID (Key3) — VARCHAR2(30) — Foreign key → SEED.SEEDID — NOT NULL
- TOOLID (Key4) — VARCHAR2(30) — Foreign key → TOOL.TOOLID — NOT NULL
- BCOUNT (Field4) — NUMBER(3)
FARM (Untitled4)
- FARMID (Key) — VARCHAR2(6) — Primary key — NOT NULL
- FARMERID (Key2) — VARCHAR2(30) — Foreign key → FARMER.FARMERID — NOT NULL
- SEEDID(FK) (Field2) — VARCHAR2(30) — NOT NULL
- GREEDNUM (Field3) — NUMBER(2)
- SUCCESSRATE (Field4) — NUMBER(10)
- STATELIST (Field5) — NUMBER(1)
- W_OK (Field6) — CHAR(1)
- B_OK (Field7) — CHAR(1)
FARMER (farmer)
- FARMERID (Key2) — VARCHAR2(30) — Primary key — NOT NULL
- FARMERNAME (Field) — VARCHAR2(30) — NOT NULL
- FARMERPW (Field2) — VARCHAR2(30) — NOT NULL
- JOINDATE (Field3) — VARCHAR2(11)
- FARMDAY (Field4) — NUMBER(2)
- CONDITION (Field5) — NUMBER(3)
- MONEY (Field6) — NUMBER(10)
HARVEST (Untitled3)
- HARVESTID (Key) — VARCHAR2(30) — Primary key — NOT NULL
- SEEDID (Key2) — VARCHAR2(30) — Foreign key → SEED.SEEDID — NOT NULL
- HARVESTNAME (Field2) — VARCHAR2(30)
- HARVESTDESC (Field3) — VARCHAR2(60)
- HARVESTPRICE (Field4) — NUMBER(10)
SEED (Untitled)
- SEEDID (Key) — VARCHAR2(30) — Primary key — NOT NULL
- SEEDNAME (Field) — VARCHAR2(30)
- SEEDDESC (Field2) — VARCHAR2(60)
- SEEDPRICE (Field3) — NUMBER(10)
- HARVESTRATE (Field4) — NUMBER(10)
TOOL (Untitled2)
- TOOLID (Key) — VARCHAR2(30) — Primary key — NOT NULL
- TOOLNAME (Field) — VARCHAR2(30)
- TOOLDESC (Field2) — VARCHAR2(60)
- TOOLPRICE (Field3) — NUMBER(10)