OTM_treeschema_india.sql~

CREATE TABLE "treemap_tree" (
    "id" serial NOT NULL PRIMARY KEY,
    "plot_id" integer NOT NULL REFERENCES "treemap_plot" ("id") DEFERRABLE INITIALLY DEFERRED,
    "tree_owner" varchar(256),
    "steward_name" varchar(256),
    "steward_user_id" integer REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED,
    "sponsor" varchar(256),
    "species_id" integer REFERENCES "treemap_species" ("id") DEFERRABLE INITIALLY DEFERRED,
    "species_other1" varchar(255),
    "species_other2" varchar(255),
    "orig_species" varchar(256),
    "dbh" double precision,
    "height" double precision,
    "canopy_height" double precision,
    "date_planted" date,
    "date_removed" date,
    "present" boolean NOT NULL,
    "last_updated" timestamp with time zone NOT NULL,
    "last_updated_by_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED,
    "s_order" integer,
    "photo_count" integer,
    "projects" varchar(20),
    "import_event_id" integer NOT NULL REFERENCES "treemap_importevent" ("id") DEFERRABLE INITIALLY DEFERRED,
    "condition" varchar(256),
    "canopy_condition" varchar(256),
    "readonly" boolean NOT NULL,
    "url" varchar(255),
    "pests" varchar(256),
    "tree_number" integer,
    "prabhagid" integer,
    "clusterid" integer,
    "propertyid" varchar(256),
    "girth_m" integer,
    "height_m" integer,
    "nest" varchar(256),
    "burrows" varchar(256),
    "flowers" varchar(256),
    "fruits" varchar(256),
    "nails" varchar(256),
    "poster" varchar(256),
    "wires" varchar(256),
    "tree_guard" varchar(256),
    "other_nuisance" boolean NOT NULL,
    "other_nuisance_desc" varchar(256),
    "health_of_tree" varchar(256),
    "ground_type" varchar(256),
    "ground_desc" varchar(256),
    "risk_due_to_tree" varchar(256),
    "risc_desc" varchar(256),
    "refer_to_dept" varchar(256),
    "special_other" varchar(256),
    "special_other_desc" varchar(256),
    "latitude" double precision,
    "longitude" double precision,
    "creation_date" timestamp with time zone,
    "device_id" varchar(12),
    "surveyor_id" varchar(256),
    "session_id" integer,
    "photo_focused1" varchar(100),
    "photo_focused2" varchar(100),
    "photo_panorama1" varchar(100),
    "photo_panorama2" varchar(100),
    "photo_other" varchar(100)
)
;