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