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