dasd

Tables (34)

AUCTION_BIDDING

  • BOARD_ID — NUMBER — Foreign key → BOARD_AUCTION.BOARD_ID — NOT NULL — 게시물ID
  • BIDDING_USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • BID — NUMBER — 입찰금

AUTHORITIES

  • AUTHORITY — VARCHAR(10) — Primary key — NOT NULL
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원

BANNED_USER

  • BANNED_NUM — NUMBER — Primary key — NOT NULL — 제재내역번호
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원번호
  • REASON — VARCHAR2(100) — NOT NULL — 제재
  • IS_BANNED — CHAR(1) — NOT NULL — 제재
  • PENALTY_DATE — DATE — 제재
  • RELESAE_DATE — DATE — 제재
  • ADMIN_USER_NUM — VARCHAR2(20) — NOT NULL — 제재

BIDDING_WINNER

  • BOARD_ID — NUMBER — Foreign key → AUCTION_BIDDING.BOARD_ID — NOT NULL — 게시물ID
  • USER_NUM — NUMBER — Foreign key → AUCTION_BIDDING.BIDDING_USER_NUM — NOT NULL — 회원

BOARD_AUCTION

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물ID
  • RENTAL_STARTING_FEE — NUMBER — NOT NULL — 경매시작금
  • BID_UNIT — NUMBER — 입찰금단위
  • AUCTION_START_DATE — DATE — NOT NULL — 경매시작일
  • AUCTION_END_DATE — DATE — NOT NULL — 경매종료일

BOARD_COMMENT

  • BOARD_CMT_ID — NUMBER — Primary key — NOT NULL — 댓글ID
  • CMT_WRITER_USER_ID — VARCHAR2(20) — NOT NULL — 댓글작성자ID
  • BOARD_CMT_CONTENT — VARCHAR2(400) — NOT NULL — 댓글내용
  • REF_NO — NUMBER — NOT NULL — 거래
  • CMT_WRITE_DATE — DATE — NOT NULL — 댓글
  • BOARD_ASSORTMENT — NUMBER — NOT NULL — 1

BOARD_COMMON

  • BOARD_ID — NUMBER — Primary key — NOT NULL — 게시물
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • PRODUCT_NAME — VARCHAR2(20) — NOT NULL — 상품
  • PRODUCT_COMMENT — VARCHAR2(2000) — NOT NULL — 상품설명
  • TRANSACTION_ADDRESS — VARCHAR2(60) — 거래
  • TRANSACTION_CATEGORY — VARCHAR2(20) — NOT NULL — 거래
  • PRODUCT_CATEGORY — VARCHAR2(20) — NOT NULL — 상품
  • CREATE_DATE — DATE — NOT NULL — 게시물
  • VIEWS — NUMBER — NOT NULL — 조회수
  • TRANSACTION_STATUS — CHAR(1) — NOT NULL — 거래

BOARD_COMMUNITY

  • COMMUNITY_BOARD_ID — NUMBER — Primary key — NOT NULL — 게시글ID
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • TITLE — VARCHAR2(20) — NOT NULL
  • CONTENT — VARCHAR2(2000) — NOT NULL
  • WRITE_DATE — DATE — NOT NULL
  • VIEWS — NUMBER — NOT NULL

BOARD_COMMUNITY_TAG

  • TAG_ID — NUMBER — Foreign key → TAG.TAG_ID — NOT NULL
  • COMMUNITY_BOARD_ID — NUMBER — Foreign key → BOARD_COMMUNITY.COMMUNITY_BOARD_ID — NOT NULL — 게시글ID

BOARD_EXCHANGE

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물
  • EXCHANGE_COUNT — NUMBER

BOARD_RENTAL

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물ID
  • RENTAL_FEE — NUMBER — NOT NULL — 대여금액
  • DEPOSIT — NUMBER — 보증금
  • RENTAL_START_DATE — DATE — NOT NULL — 대여시작일
  • RENTAL_END_DATE — DATE — NOT NULL — 대여종료일

BOARD_SHARING

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물ID
  • SHARING_COUNT — NUMBER — NOT NULL — 나눔수량

BOARD_TAG

  • TAG_ID — NUMBER — Foreign key → TAG.TAG_ID — NOT NULL
  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물

CATEGORY

  • CATEGORY_ID — NUMBER — Primary key — NOT NULL
  • CATEGORY — VARCHAR2(64) — NOT NULL — 어떤
  • REF_NO — NUMBER — NOT NULL

CHAT_MESSAGE

  • MESSAGE_ID — NUMBER — Primary key — NOT NULL — 메세지
  • CHATROOM_ID — NUMBER — Foreign key → CHAT_ROOM.CHATROOM_ID — NOT NULL — 오픈
  • SENT_AT — DATE — NOT NULL — 메세지
  • CHAT_CONTENT — VARCHAR2(2000) — NOT NULL — 메세지

CHAT_PARTICIPANT

  • CHATROOM_ID — NUMBER — Foreign key → CHAT_ROOM.CHATROOM_ID — NOT NULL — 오픈
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원

CHAT_ROOM

  • CHATROOM_ID — NUMBER — Primary key — NOT NULL — 채팅방
  • USER_NUM — NUMBER — NOT NULL — 회원
  • REF_NUM — NUMBER — NOT NULL — 1

CUSTOMER_SERVICE

  • CS_NUM — NUMBER — Primary key — NOT NULL — 문의
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • CS_TITLE — VARCHAR2(100) — NOT NULL — 제목
  • CS_CONTENT — VARCHAR2(1000) — NOT NULL — 내용
  • CS_DATE — DATE — NOT NULL — 문의
  • CS_REPLY — VARCHAR2(1000) — 답변
  • CS_REPLY_DATE — DATE
  • STATUS — VARCHAR2(20) — 상태

DIBS

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물ID
  • LIKES_USER_ID — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원

EXCHANGE_PRODUCT

  • EXCHANGE_PRODUCT_NUM — NUMBER — Primary key — NOT NULL — 제시상품번호
  • BOARD_ID — NUMBER — Foreign key → BOARD_EXCHANGE.BOARD_ID — NOT NULL — 게시물
  • EXCHANGE_USER_ID — VARCHAR2(20) — NOT NULL — 제시자_회원아이디
  • EXCHANGE_PRODUCT — VARCHAR2(200) — NOT NULL — 제시상품

EXCHANGE_WANTED

  • WANTED_PRODUCT_NO — NUMBER — Primary key — NOT NULL
  • BOARD_ID — NUMBER — Foreign key → BOARD_EXCHANGE.BOARD_ID — NOT NULL — 게시물
  • PRIORITY — NUMBER
  • WANTED_PRODUCT — VARCHAR2(200)

FILE

  • FILE_ID — NUMBER — Primary key — NOT NULL
  • PATH_NUM — NUMBER — NOT NULL
  • FILE_NAME — VARCHAR2(100)
  • REF_NO — NUMBER — NOT NULL
  • FILE_ASSORTMENT — NUMBER — NOT NULL — 1

FILE_PATH

  • PATH_ID — NUMBER — Primary key — NOT NULL
  • PATH — VARCHAR2(300)

MANNER

  • MANNER_EVALUATION_NUM — NUMBER — Primary key — NOT NULL — 고유
  • EVALUATOR_USER_NUM — NUMBER — NOT NULL — 회원
  • TARGET_USER_NUM — VARCHAR2(20) — NOT NULL
  • SCORE — NUMBER — NOT NULL
  • COMENT — VARCHAR2(1000) — NOT NULL

OPENCHATROOM_TAG

  • TAG_ID — NUMBER — Foreign key → TAG.TAG_ID — NOT NULL
  • CHATROOM_ID — NUMBER — Foreign key → OPEN_CHAT.CHATROOM_ID — NOT NULL — 오픈

OPEN_CHAT

  • CHATROOM_ID — NUMBER — Foreign key → CHAT_ROOM.CHATROOM_ID — NOT NULL — 오픈
  • OPEN_CHAT_ROOM_NAME — VARCHAR2(50)
  • OPEN_CHAT_COUNT — NUMBER
  • MAX_CHATROOM_COUNT — NUMBER
  • DESCRIPTION — VARCHAR2(2000)

PERISISTENT_LOGINS

  • SERIES_ID — VARCHAR2(64) — Primary key — NOT NULL
  • USER_NUM — NUMBER — NOT NULL — 회원
  • TOKEN_VALUE — VARCHAR2(64) — NOT NULL
  • LAST_USED — TIMESTAMP — NOT NULL

PROFILE

  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — PFK
  • IMAGE_URL — VARCHAR2(255) — NOT NULL
  • UPLOADED_AT — DATE — NOT NULL

REACTION

  • REACTION_NUM — NUMBER — Primary key — NOT NULL
  • REACTION_USER_NUM — NUMBER — NOT NULL — 회원
  • TARGET_TYPE — VARCHAR2(20) — 대상종류
  • TARGET_ID — NUMBER — NOT NULL — 대상ID
  • REACTION_TYPE — VARCHAR2(20) — NOT NULL — 반응종류

REPORTS

  • REPORT_NUM — VARCHAR2(20) — Primary key — NOT NULL — 신고
  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • TYPE — VARCHAR2(20) — NOT NULL — 신고
  • TARGET_ID — VARCHAR2(20) — NOT NULL — 신고
  • REASON — VARCHAR2(60) — NOT NULL — 신고사유
  • DETAIL_REASON — VARCHAR2(1000) — NOT NULL — 상세사유
  • STATUS — VARCHAR2(20) — NOT NULL — 접수/처리중/처리완료
  • CREATED_AT — DATE — NOT NULL — 신고일
  • PROCESSED_AT — DATE — 처리

SOCIAL_USER

  • USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • SOCIAL — VARCHAR2(20) — NOT NULL — "GOOGLE"
  • SOCIAL_ID — VARCHAR2(100) — NOT NULL

TAG

  • TAG_ID — NUMBER — Primary key — NOT NULL
  • TAG_CONTENT — VARCHAR2(20) — NOT NULL

TRANSACTION_END

  • BOARD_ID — NUMBER — Foreign key → BOARD_COMMON.BOARD_ID — NOT NULL — 게시물
  • TRADER_USER_NUM — NUMBER — Foreign key → USER_TB.USER_NUM — NOT NULL — 회원
  • TRANSACTION_END_TIME — DATE

USER_TB

  • USER_NUM — NUMBER — Primary key — NOT NULL — 회원
  • USER_ID — VARCHAR2(20) — 회원아이디
  • USER_PWD — VARCHAR2(20) — NOT NULL — 회원
  • NICK_NAME — VARCHAR2(30) — NOT NULL — 닉네임
  • EMAIL — VARCHAR2(100) — NOT NULL — 이메일
  • PHONE — VARCHAR2(20) — NOT NULL — 전화번호
  • CREATE_DATE — DATE — NOT NULL — 계정
  • BIRTH — DATE — NOT NULL — 생년월일
  • IS_QUIT — CHAR(1) — NOT NULL — 탈퇴여부
  • ADDRESS — VARCHAR2(100) — NOT NULL — 주소
  • USER_INF_VALIDITY_PERIOD — VARCHAR2(10) — NOT NULL