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