UNILAND_ERD

Tables (14)

BOARD_TBL

  • BOARD_NO — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • BOARD_CATEGORY — VARCHAR2(30)
  • BOARD_TITLE — VARCHAR2(200)
  • BOARD_CONTENT — CLOB
  • VIEW_COUNT — NUMBER
  • LIKE_COUNT — NUMBER
  • COMMENT_COUNT — NUMBER
  • IS_HOT — CHAR(1)
  • WRITE_DATE — TIMESTAMP
  • UPDATE_DATE — TIMESTAMP

COMMENT_TBL

  • COMMENT_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • COMMENT_CONTENT — VARCHAR2(1000)
  • COMMENT_DATE — TIMESTAMP
  • LIKE_COUNT — NUMBER
  • DELETE_YN — CHAR(1)

Contract

  • CONTRACT_NO — NUMBER — Primary key — NOT NULL
  • PROPERTIES_NO — NUMBER — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • BROKER_ID — VARCHAR2(50) — NOT NULL
  • CONTRACT_STATUS — VARCHAR2(20)
  • DEPOSIT_PRICE — NUMBER(19)
  • CONTRACT_AT — DATE

INQUIRY

  • INQUIRY_NO — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • BROKER_ID — VARCHAR2(50) — NOT NULL
  • INQUIRY_SUBJECT — VARCHAR2(300)
  • INQUIRY_CONTENT — VARCHAR2(2000)
  • INQUIRY_DATE — TIMESTAMP
  • INQUIRY_STATUS — VARCHAR2(12)

LIKE_TBL

  • LIKE_KEY — VARCHAR2(255) — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50)
  • TARGET_TYPE — VARCHAR2(50)
  • TARGET_ID — NUMBER
  • CREATED_AT — TIMESTAMP

NOTICE_TBL

  • NOTICE_NO — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • NOTICE_SUBJECT — VARCHAR2(300)
  • NOTICE_CONTENT — VARCHAR2(4000)
  • NOTICE_WRITER — VARCHAR2(30)
  • NOTICE_DATE — TIMESTAMP
  • VIEW_COUNT — NUMBER

PROPERTIES_IMG_TBL

  • IMG_NO — NUMBER — Primary key — NOT NULL
  • PROPERTIES_NO — NUMBER — NOT NULL
  • BROKER_ID — VARCHAR2(50) — NOT NULL
  • IMG_PATH — VARCHAR2(500)
  • IMG_RENAME — VARCHAR2(300)
  • IMG_ORIGINAL_NAME — VARCHAR2(200)
  • IMG_ORDER — NUMBER

PROPERTIES_TBL

  • PROPERTIES_NO — NUMBER — Primary key — NOT NULL
  • BROKER_ID — VARCHAR2(50) — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • PROPERTIES_NAME — VARCHAR2(100)
  • PROPERTY_TYPE — VARCHAR2(30)
  • PRICE_TYPE — VARCHAR2(10)
  • PARKING_LOT — CHAR(1)
  • CONTRACT_AREA — NUMBER(7,2)
  • PRIVATE_AREA — NUMBER(7,2)
  • DEPOSIT — NUMBER
  • MONTHLY_RENT — NUMBER
  • MAINTENANCE_FEE — NUMBER
  • MAINTENANCE_INCL — CHAR(1)
  • STATUS — VARCHAR2(10)
  • PROVINCE — VARCHAR2(50)
  • DISTRICT — VARCHAR2(50)
  • ROAD_ADDRESS — VARCHAR2(200) — NOT NULL
  • PARCEL_ADDRESS — VARCHAR2(200)
  • ADDRESS_DETAIL — VARCHAR2(200)
  • ZIP_CODE — VARCHAR2(50)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • DELETED_AT — TIMESTAMP
  • CONTRACT_STATUS — CHAR(1)
  • CONTRACT_AT — TIMESTAMP
  • MEMO — CLOB

PROPERTY_OPTION

  • PROPERTIES_NO — NUMBER — Primary key — NOT NULL
  • AIR_CONDITIONER — CHAR(1)
  • REFRIGERATOR — CHAR(1)
  • SINK — CHAR(1)
  • SHOE_RACK — CHAR(1)
  • WASHER — CHAR(1)
  • WARDROBE — CHAR(1)
  • INDUCTION — CHAR(1)
  • GAS_STOVE — CHAR(1)
  • MICROWAVE — CHAR(1)
  • AIR_DRESSER — CHAR(1)

REALTOR_TBL

  • BROKER_ID — VARCHAR2(50) — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • OFFICE_NAME — VARCHAR2(50)
  • REALTOR_NAME — VARCHAR2(20)
  • REALTOR_ADDRESS — VARCHAR2(200)
  • REALTOR_PHONE — VARCHAR2(20)
  • REALTOR_EMAIL — VARCHAR2(50)
  • BUSINESS_NUM — VARCHAR2(15) — NOT NULL

USER_IMG_TBL

  • USER_ID — VARCHAR2(50) — Primary key — NOT NULL
  • IMG_NO — NUMBER
  • IMG_PATH — VARCHAR2(500)
  • IMG_RENAME — VARCHAR2(300)
  • IMG_ORIGINAL_NAME — VARCHAR2(200)
  • IMG_ORDER — NUMBER

USER_TBL

  • USER_ID — VARCHAR2(50) — Primary key — NOT NULL
  • USER_PASSWORD — VARCHAR2(100)
  • USER_NAME — VARCHAR2(20)
  • USER_AGE — NUMBER
  • USER_GENDER — VARCHAR2(6)
  • USER_PHONE — VARCHAR2(20)
  • USER_EMAIL — VARCHAR2(50)
  • USER_SCHOOL — VARCHAR2(20)
  • USER_BUSINESS — CHAR(1)
  • ADMIN — CHAR(1)

Untitled2

  • USER_ID — VARCHAR2(50) — Primary key — NOT NULL
  • TOKEN — VARCHAR2(500)
  • CREATED_AT — TIMESTAMP
  • EXPIRES_AT — TIMESTAMP

interest

  • INTEREST_ID — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — NOT NULL
  • PROPERTIES_NO — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP
  • IS_FAVORITE — CHAR(1)
  • IS_RECOMMENDED — CHAR(1)
  • IS_CHECKED — CHAR(1)