--- Table: default_reservations --- [ { "Field": "resv_id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment" }, { "Field": "cl_id", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "flt_id", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "flat_num", "Type": "varchar(30)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "floor", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "bldg_id", "Type": "varchar(30)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "prj_id", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "resv_date", "Type": "varchar(70)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "resv_by", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "payment_type", "Type": "bigint(20)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "" }, { "Field": "tot_inst_years", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "inst_start_date", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "tot_inst", "Type": "double", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "alt_id", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "upd_by", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "flt_order", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "park", "Type": "varchar(1)", "Null": "NO", "Key": "", "Default": "N", "Extra": "" }, { "Field": "park_count", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "garden", "Type": "varchar(1)", "Null": "NO", "Key": "", "Default": "N", "Extra": "" }, { "Field": "garden_size", "Type": "float", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "roof", "Type": "varchar(1)", "Null": "NO", "Key": "", "Default": "N", "Extra": "" }, { "Field": "roof_size", "Type": "float", "Null": "NO", "Key": "", "Default": "1", "Extra": "" }, { "Field": "sess", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "2", "Extra": "" }, { "Field": "res_kind", "Type": "varchar(1)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "num_days", "Type": "varchar(2)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "subsess", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" } ] --- Table: garden_inst_table --- [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment" }, { "Field": "year", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "month", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "inst_type", "Type": "varchar(40)", "Null": "YES", "Key": "", "Default": "monthly", "Extra": "" }, { "Field": "inst_name", "Type": "varchar(60)", "Null": "YES", "Key": "", "Default": "\u0642\u0633\u0637 \u062d\u062f\u064a\u0642\u0647", "Extra": "" }, { "Field": "gard_inst_amount", "Type": "float", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "flat_num", "Type": "varchar(40)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "bldg_no", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "area", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "total", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "prj_id", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "comments", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "full_date", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "yr_mon", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "sess", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "1", "Extra": "" } ] --- Table: default_park_inst --- [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment" }, { "Field": "prj_id", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "bldg_no", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "park_no", "Type": "varchar(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "yr", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "mon", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "" }, { "Field": "inst_amount", "Type": "float", "Null": "NO", "Key": "", "Default": "0", "Extra": "" }, { "Field": "date", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "" }, { "Field": "yr_mon", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "" } ]