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