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)