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