agriculture aid

Tables (7)

Aid Classification (Untitled5)

  • clssficationId — str — Primary key
  • aidId — str — Foreign key → farmService.aidId
  • userId — str — Foreign key → farmService.userId
  • illegalStatusId — Foreign key → farmService.illegalStatusId
  • userId (userId2) — Foreign key → farmService.userId
  • smallMachine — str
  • supplies — str
  • bigMachine — str

Users (Untitled)

  • userId — str — Primary key
  • name — str
  • age — str
  • address — str
  • affiliation — str
  • familyAmount — str
  • farmlandAmount — str
  • farmAidAmount — str
  • financingAmount — str
  • ID card number — str
  • illegalStatus — bool

family (Untitled2)

  • userId — str — Foreign key → Users.userId
  • name — str
  • relation — enum
  • age — str
  • ID card number — str

farmService (Untitled4)

  • aidId — Primary key
  • userId — str — Foreign key → Users.userId
  • illegalStatusId — Foreign key → illegaldetails.illegalStatusId
  • userId (userId2) — Foreign key → illegaldetails.userId
  • year — str
  • classification — enum
  • serviceName — str
  • Amount — int

farmland (Untitled3)

  • userId — str — Foreign key → Users.userId
  • possession/rent (Ownership) — bool
  • owner — str
  • extent — str
  • farmAddress — str

financing (Untitled6)

  • userId — Foreign key → Users.userId
  • rate — str
  • redemption — bool
  • period — str

illegaldetails (Untitled7)

  • illegalStatusId — Primary key
  • userId — Foreign key → Users.userId
  • restrictionYear
  • amount
  • restrictionPeriod