PROPERTY
Tables (6)
PROPERTY_AGENCY (1)
- AGENCY_NO (PK) — NUMBER — Primary key — NOT NULL
- AGENCY_NAME (Field) — VARCHAR
- AGENCY_CEO (Field2) — VARCHAR
- AGENCY_PHONE (Field3) — VARCHAR
- AGENCY_REGNO (Field4) — VARCHAR
- AGENCY_ZIPCODE (Field5) — VARCHAR
- AGENCY_ADDR (Field6) — VARCHAR
PROPERTY_AGENT (2)
- AGENT_NO (PK) — NUMBER — Primary key — NOT NULL
- AGENT_AGENCY (FK) — NUMBER — Foreign key → PROPERTY_AGENCY.AGENCY_NO — NOT NULL
- AGENT_NAME (Field) — VARCHAR
- AGENT_PHONE (Field2) — VARCHAR
- AGENT_INDATE (Field3) — VARCHAR
- AGENT_OUTDATE (Field4) — VARCHAR
- AGENT_CLASS (Field5) — VARCHAR
- AGENT_ID (Field6) — VARCHAR
- AGENT_PW (Field7) — VARCHAR
PROPERTY_CONTRACT (6)
- CONTRACT_NO (PK) — NUMBER — Primary key — NOT NULL
- CONTRACT_ESTATE (FK) — NUMBER — Foreign key → PROPERTY_ESTATE.ESTATE_NO — NOT NULL
- CONTRACT_INDATE (Field) — VARCHAR
- CONTRACT_OUTDATE (Field2) — VARCHAR
- CONTRACT_DEPOSIT (Field3) — VARCHAR
- CONTRACT_MIDDEPOSIT (Field4) — VARCHAR
- CONTRACT_LEFTDEPOSIT (Field5) — VARCHAR
- CONTRACT_LOANDEPOSIT (Field6) — VARCHAR
- CONTRACT_SPECIAL (Field7) — VARCHAR
- CONTRACT_REMARK (Field8) — VARCHAR
PROPERTY_ESTATE (4)
- ESTATE_NO (PK) — NUMBER — Primary key — NOT NULL
- ESTATE_OWENER (FK2) — NUMBER — Foreign key → PROPERTY_USER.USER_NO — NOT NULL
- ESTATE_AGENT (FK) — NUMBER — Foreign key → PROPERTY_AGENT.AGENT_NO — NOT NULL
- ESTATE_TENANT (FK3) — VARCHAR
- ESTATE_NAME (Field) — VARCHAR
- ESTATE_ADDR (Field2) — VARCHAR
- ESTATE_ADDR (Field3) — VARCHAR
- ESTATE_ZIPCODE (Field4) — VARCHAR
- ESTATE_FLOOR (Field5) — VARCHAR
- ESTATE_ROOM (Field6) — VARCHAR
- ESTATE_BATHROOM (Field7) — VARCHAR
- ESTATE_REMARK (Field8) — VARCHAR
PROPERTY_LIKE (5)
- LIKE_NO (PK) — NUMBER — Primary key — NOT NULL
- LIKE_USER (FK) — NUMBER — Foreign key → PROPERTY_USER.USER_NO — NOT NULL
- LIKE_ESTATE (FK2) — NUMBER — Foreign key → PROPERTY_ESTATE.ESTATE_NO — NOT NULL
PROPERTY_USER (3)
- USER_NO (PK) — NUMBER — Primary key — NOT NULL
- USER_ID (Field) — VARCHAR
- USER_PW (Field2) — VARCHAR
- USER_PHONE (Field3) — VARCHAR
- USER_INDATE (Field4) — VARCHAR
- USER_OUTDATE (Field5) — VARCHAR
- USER_EMAIL (Field6) — VARCHAR
- USER_ADDR (Field7) — VARCHAR