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