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)