Register Of Charities

CREATE TABLE register_of_charities (
  "reg_charity_number" BIGINT,
  "charity_name" VARCHAR,
  "date_registered" TIMESTAMP,
  "status" VARCHAR,
  "date_for_financial_year_ending" VARCHAR,
  "total_income" BIGINT,
  "total_spending" BIGINT,
  "charitable_spending" BIGINT,
  "income_generation_and_governance" BIGINT,
  "public_address" VARCHAR,
  "website" VARCHAR,
  "email" VARCHAR,
  "telephone" VARCHAR,
  "company_number" BIGINT,
  "what_the_charity_does" VARCHAR,
  "who_the_charity_helps" VARCHAR,
  "how_the_charity_works" VARCHAR,
  "charitable_purposes" VARCHAR,
  "other_name" VARCHAR,
  "type_of_governing_document" VARCHAR,
  "financial_period_start" VARCHAR,
  "financial_period_end" VARCHAR,
  "total_income_previous_financial_period" BIGINT,
  "employed_staff" BIGINT,
  "uk_and_ireland_volunteers" BIGINT,
  "income_from_donations_and_legacies" BIGINT,
  "income_from_charitable_activities" BIGINT,
  "income_from_other_trading_activities" BIGINT,
  "income_from_investments" BIGINT,
  "income_from_other" BIGINT,
  "total_income_and_endowments" BIGINT,
  "expenditure_on_raising_funds" BIGINT,
  "expenditure_on_charitable_activities" BIGINT,
  "expenditure_on_governance" BIGINT,
  "expenditure_on_other" BIGINT,
  "total_expenditure" BIGINT,
  "assets_and_liabilities_total_fixed_assets" BIGINT,
  "total_net_assets_and_liabilities" BIGINT,
  "unnamed_38" VARCHAR
);