taxmap

Tables (5)

taxmap (subsidy)

  • id — BIGINT — Primary key — NOT NULL
  • orgInfo (org_info_id) — BIGINT — Foreign key → taxmap.id — NOT NULL
  • govOffice (gov_office) — VARCHAR(255)
  • financialYear (financial_year) — VARCHAR(255)
  • businessYear (business_year) — VARCHAR(255)
  • businessName (business_name) — VARCHAR(255)
  • orgName (org_name) — VARCHAR(255)
  • representativeName (representative_name) — VARCHAR(255)
  • phoneNumber (phone_number) — VARCHAR(255)
  • address — VARCHAR(255)
  • totalBusinessExpense (total_business_expense) — BIGINT
  • govExpense (gov_expense) — BIGINT
  • localExpense (local_expense) — BIGINT
  • selfExpense (self_expense) — BIGINT
  • requestedSubsidy (requested_subsidy) — VARCHAR(255)
  • govBudget (gov_budget) — BIGINT
  • localBudget (local_budget) — BIGINT
  • requestedPaid (requested_paid) — BIGINT
  • authorityPaid (authority_paid) — BIGINT
  • businessPurpose (business_purpose) — TEXT
  • businessDescription (business_description) — TEXT
  • businessDuration (business_duration) — TEXT
  • businessLocation (business_location) — TEXT
  • subjectNumber (subject_number) — TEXT
  • miscExpense (misc_expense) — TEXT
  • proceedsProcessMethod (proceeds_process_method) — TEXT
  • applierAsset (applier_asset) — TEXT
  • expectedBenefit (expected_benefit) — TEXT
  • performanceGoal (performance_goal) — TEXT
  • considerations — TEXT
  • likes — INT
  • dislikes

taxmap (organization)

  • id — BIGINT — Primary key — NOT NULL
  • coordsInfo (coords_info_id) — BIGINT — Foreign key → taxmap.id — NOT NULL
  • orgName (org_name) — VARCHAR(255)
  • representativeName (representative_name) — VARCHAR(255)
  • phoneNumber (phone_number) — VARCHAR(255)
  • address — VARCHAR(255)

taxmap (coords)

  • id — BIGINT — Primary key — NOT NULL
  • address — VARCHAR(255)
  • latitude — DOUBLE
  • longitude — DOUBLE

taxmap (user)

  • id — BIGINT — Primary key — NOT NULL
  • userName (user_name) — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255)

taxmap (comments)

  • subsidyId (subsidy_id) — BIGINT — Foreign key → taxmap.id — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → taxmap.id — NOT NULL
  • uploadTime (upload_time) — TIMESTAMP
  • body — TEXT