0511
Tables (5)
FAVORITE
- favorite_id — INT
- member_id — INT — NOT NULL
- property_id — INT — NOT NULL
- reg_date — DATETIME — NOT NULL
LOGS
- log_id — INT
- member_id — INT
- action_type — VARCHAR(50) — NOT NULL
- target_type — VARCHAR(50)
- target_id — INT
- description — TEXT
- ip_address — VARCHAR(50)
- action_date — DATETIME — NOT NULL
MEMBER
- member_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- user_type — ENUM('REGULAR', 'AGENT') — NOT NULL
- reg_date — DATETIME — NOT NULL
- last_login — DATETIME
- status — ENUM('ACTIVE', 'INACTIVE', 'SUSPENDED') — NOT NULL
PROPERTY
- property_id — INT
- member_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- property_type — ENUM('APARTMENT', 'HOUSE', 'COMMERCIAL', 'LAND') — NOT NULL
- transaction_type — ENUM('SALE', 'RENT', 'LEASE') — NOT NULL
- address — VARCHAR(255) — NOT NULL
- city — VARCHAR(100) — NOT NULL
- state — VARCHAR(100) — NOT NULL
- zip_code — VARCHAR(20) — NOT NULL
- price — DECIMAL(15, 2) — NOT NULL
- size_sqm — DECIMAL(10, 2) — NOT NULL
- rooms — INT
- bathrooms — INT
- description — TEXT
- build_year — INT
- reg_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
- status — ENUM('AVAILABLE', 'PENDING', 'SOLD', 'RENTED', 'EXPIRED') — NOT NULL
RESERVATION
- reservation_id — INT
- property_id — INT — NOT NULL
- member_id — INT — NOT NULL
- reservation_date — DATETIME — NOT NULL
- message — TEXT
- reg_date — DATETIME — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'COMPLETED', 'CANCELLED') — NOT NULL