suppot-connection
Tables (7)
asset (CopyOfUntitled2)
- asset_id (Key) — LONG — Primary key — NOT NULL
- my_asset (Field) — INT
- suppot_remain (Field2) — INT
available_support (Untitled2)
- available_id (Key) — LONG — Primary key — NOT NULL
- total_amount (Field) — INT
- cash_amount (Field2) — INT
- financial_amount (Field3) — INT
condition (Untitled3)
- condition_id (Key) — long — Primary key — NOT NULL
- province (Field) — VARCHAR(5)
- district (Field2) — VARCHAR(5)
- income_group (Field3) — INT
- annual_income (Field4) — INT
- is_married (Field5) — TINIINT
- have_child (Field6) — TINIINT
- child_age (Field7) — INT
- is_pregnant (Field8) — TINIINT
- occupation (Field14) — INT
- is_temporary (Field10) — TINIINT
- is_unemployed (Field11) — TINIINT
- business_type (Field9) — VARCHAR(10)
- business_scale (Field13) — INT
- annual_sale (Field12) — INT
support (Untitled4)
- support_id (Key) — LONG — Primary key — NOT NULL
- condition_id (Key3) — long — Foreign key → condition.condition_id — NOT NULL
- name (Field5) — VARCHAR(50)
- category (Field4) — VARCHAR(10)
- site (Field6) — VARCHAR(50)
- local_chk (Field2) — TINIINT
- type (Field3) — INT
- amount (Field7) — INT
- status (Field) — tinyint
support_detail (Untitled8)
- support_id (Key) — LONG — Foreign key → support.support_id — NOT NULL
- qualification (Field) — TEXT
- info (Field3) — TEXT
- apply_info (Field2) — TEXT
- required_documents (Field6) — TEXT
- deadline (Field5) — DATETIME
- url (Field4) — VARCHAR(100)
- contact (Field7) — VARCHAR(50)
user (Untitled)
- user_id (Key) — LONG — Primary key — NOT NULL
- username (Field) — VARCHAR(15)
- agency (Field8) — VARCHAR(10)
- phone_number (Field2) — VARCHAR(20)
- age (Field7) — INT
- condition_id (Key2) — LONG — Foreign key → condition.condition_id
- available_id (Key3) — LONG — Foreign key → available_support.available_id — NOT NULL
- asset_id (Key4) — LONG — Foreign key → asset.asset_id — NOT NULL
user-support (Untitled9)
- user_id (Key2) — LONG — Foreign key → user.user_id — NOT NULL
- support_id (Key) — LONG — Foreign key → support.support_id — NOT NULL
- update_date (Field) — DATETIME