miniproject

Tables (9)

cms

  • cidx — int — Primary key — NOT NULL
  • mname — varchar(25) — NOT NULL
  • memail — varchar(100) — NOT NULL
  • mtel — char(11) — NOT NULL
  • cmsdate — date — NOT NULL
  • cmstext — text — NOT NULL
  • cdate — timestamp — NOT NULL

cms_property_status

  • cidx — INT — Primary key — NOT NULL
  • pstatus — INT — Primary key — NOT NULL
  • cidx (cidx2) — int — Foreign key → cms.cidx — NOT NULL
  • pstatus (pstatus2) — int — Foreign key → property_status.pstatus — NOT NULL

cms_property_type

  • cidx — INT — Primary key — NOT NULL
  • ptype — INT — Primary key — NOT NULL
  • cidx (cidx2) — int — Foreign key → cms.cidx — NOT NULL
  • ptype (ptype2) — int — Foreign key → property_type.ptype — NOT NULL

member

  • midx — int — NOT NULL
  • memail — varchar(100) — NOT NULL
  • mpass — varchar(50) — NOT NULL
  • mname — varchar(25) — NOT NULL
  • mtel — char(11) — NOT NULL
  • age_terms — enum('Y','N') — NOT NULL
  • service_terms — enum('Y','N') — NOT NULL
  • privacy_terms — enum('Y','N') — NOT NULL
  • marketing_terms — enum('Y','N')
  • mdate — timestamp — NOT NULL

property

  • pidx — int — Primary key — NOT NULL
  • pname — varchar(50) — NOT NULL
  • ptype — int — NOT NULL
  • psalsetype — int — NOT NULL
  • paddress — varchar(255) — NOT NULL
  • punit — int — NOT NULL
  • pblocks — int — NOT NULL
  • psaledate — date — NOT NULL
  • pmoveindate — date — NOT NULL
  • pheating — int — NOT NULL
  • pbuilder — varchar(50) — NOT NULL
  • pstatus — int — NOT NULL
  • pmig — varchar(255)
  • pdate — timestamp — NOT NULL

property_heating

  • pheating — int — Primary key — NOT NULL
  • typename — varchar(20) — NOT NULL

property_sale

  • psalsetype — int — Primary key — NOT NULL
  • typename — varchar(20) — NOT NULL

property_status

  • pstatus — int — Primary key — NOT NULL
  • typename — varchar(10) — NOT NULL

property_type

  • ptype — int — Primary key — NOT NULL
  • typename — varchar(20) — NOT NULL