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