second_life(clone)
Tables (12)
BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL
- CATEGORY_NO — NUMBER — NOT NULL
- BOARD_WRITER — NUMBER — NOT NULL
- TRADE_CATEGORY_NO — NUMBER — NOT NULL
- PRODUCT_NAME — VARCHAR2(60) — NOT NULL
- PRICE — NUMBER — NOT NULL
- CONDITION — NUMBER — NOT NULL
- CONTENT — VARCHAR2(3000) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MODIFY_DATE — DATE — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
- SALE_CONDITION — CHAR(1 CHAR) — NOT NULL
BOARD_IMG
- BOARD_IMG_NO — NUMBER — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- CHANGE_NAME — VARCHAR2(30)
- IMG_PATH — VARCHAR2(300) — NOT NULL — 파일명 외의 경로명만 관리
- STATUS — CHAR(1 CHAR) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MODIFY_DATE — DATE — NOT NULL
CATEGORY
- CATEGORY_NO — NUMBER — Primary key — NOT NULL
- CATEGORY_NAME — VARCHAR2(45) — NOT NULL — UNIQUE 제약 조건
CHAT_MESSAGE
- CHAT_MESSAGE_NO — NUMBER — Primary key — NOT NULL — 해당 NO만 SEQ가 아닌, 해당 채팅방 메세지 갯수 + 1로 설정
- CHAT_ROOM_NO — NUMBER — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- MESSAGE — VARCHAR2(600) — NOT NULL
- USER_NO — NUMBER — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
CHAT_ROOM
- CHAT_ROOM_NO — NUMBER — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- SECOND_USER_NO — NUMBER — NOT NULL
- FIRST_USER_NO — NUMBER — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
- NOTICE — CHAR(1 CHAR) — NOT NULL
FAVORITE_LIST
- FAVORITE_LIST_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
PROFILE_IMG
- PROFILE_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- CHANGE_NAME — VARCHAR2(30) — NOT NULL
- PROFILE_PATH — VARCHAR2(300) — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MODIFY_DATE — DATE — NOT NULL
REPORT
- REPORT_NO — NUMBER — Primary key — NOT NULL
- TARGET_NO — NUMBER — NOT NULL
- TARGET_USER_NO — NUMBER — NOT NULL
- WRITER_NO — NUMBER — NOT NULL
- CONTENT — VARCHAR2(3000) — NOT NULL
- CREAET_DATE — DATE — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
REPORT_IMG
- REPORT_IMG_NO — NUMBER — Primary key — NOT NULL
- REPORT_NO — NUMBER — NOT NULL
- CHANGE_NAME — VARCHAR2(30) — NOT NULL
- REPORT_PATH — VARCHAR2(300) — NOT NULL
- STATUS — CHAR(1 CHAR) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MODIFY_DATE — DATE — NOT NULL
REVIEW
- REVIEW_NO — NUMBER — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- REVIEW_USER_NO — NUMBER — NOT NULL
- REVIEWED_USER_NO — NUMBER — NOT NULL
- CONTENT — VARCHAR2(3000) — NOT NULL
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- STATUS — CHAR(1 CHAR)
TRADE_CATEGORY
- TRADE_CATEGORY_NO — NUMBER — Primary key — NOT NULL
- TRADE_METHOD — VARCHAR2(30) — NOT NULL — UQ
USER
- USER_NO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(45) — NOT NULL — UNIQUE 제약 조건
- PWD — VARCHAR2(45) — NOT NULL
- NICKNAME — VARCHAR2(30) — NOT NULL — UNIQUE 제약 조건
- NAME — VARCHAR2(15) — NOT NULL
- ADDRESS — VARCHAR2(120)
- PHONE — VARCHAR2(15 CHAR) — NOT NULL
- EMAIL — VARCHAR2(30 CHAR) — NOT NULL — UNIQUE 제약 조건 (계정 인증 수단)
- STATUS — CHAR(1 CHAR)
- CREATE_DATE — DATE — NOT NULL
- MODIFY_DATE — DATE — NOT NULL
- REPORT_COUNT — NUMBER
- ADMIN_AUTH — CHAR(1 CHAR) — NOT NULL