market
테이블 (10)
거래리뷰 포인트 (REVIEW_POINT)
- 리뷰포인트 번호 (REVIEW_POINT_NO) — number — 기본 키 — NOT NULL
- REVIEW_POINT_WRITER — VARCHAR2(30 BYTE)
- REVIEW_POINT_RECEIVER — VARCHAR2(30 BYTE)
- REVIEW_POINT_POINT — VARCHAR2(20 BYTE)
거래후기 설문조사 (REVIEW_SURVEY)
- 설문 문항1 (REVIEW_SURVEY_ONE) — VARCHAR2(50 BYTE)
- 설문 문항2 (REVIEW_SURVEY_TWO) — VARCHAR2(50 BYTE)
- 설문 문항3 (REVIEW_SURVEY_THREE) — VARCHAR2(50 BYTE)
- 설문 문항4 (REVIEW_SURVEY_FOUR) — VARCHAR2(50 BYTE)
- 설문 문항5 (REVIEW_SURVEY_FIVE) — VARCHAR2(50 BYTE)
경매 테이블 (auction)
- 경매 번호 (auction_no) — number — 기본 키 — NOT NULL
- auction_title — varchar2(50)
- auction_writer — varchar2(15)
- auction_content — varchar2(2000)
- auction_original_filename — varchar2(100)
- auction_renamed_filename — varchar2(100)
- auction_readcount — number
- auction_date — date
- auction_type — char(1)
- auction_deldate — date
- auction_deltype — char(1)
공지사항 (notice)
- 공지사항 번호 (notice_no) — number — 기본 키 — NOT NULL
- notice_title — varchar2(50)
- notice_writer — varchar2(15)
- notice_content — varchar2(2000)
- notice_original_filename — varchar2(100)
- notice_renamed_filename — varchar2(100)
- notice_date — date
- notice_readcount — number
- notice_deldate — date
- notice_deltype — char(1)
댓글 테이블 (comment_table)
- comment_no — varchar2(10) — 기본 키 — NOT NULL
- comment_level — number
- user_id — varchar2(30) — NOT NULL
- comment_content — varchar2(1000)
- comment_ref — number
- comment_date — date
- comment_deldate — date
- comment_deltype — char(1)
무료나눔 게시판 (free_product)
- 무료나눔 번호 (free_product_no) — number — 기본 키
- free_product_title — varchar2(50)
- free_product_writer — varchar2(15)
- free_product_content — varchar2(2000)
- free_product_original_filename — varchar2(100)
- free_product_renamed_filename — varchar2(100)
- free_product_date — date
- free_product_deldate — date
- free_product_deltype — char(1)
신고 테이블 (declaration)
- 신고 번호 (declaration_no) — number — 기본 키 — NOT NULL
- declaration_title — varchar2(50)
- declaration_writer — varchar2(15)
- declaration_receiver — varchar2(15)
- declaration_content — varchar2(2000)
- declaration_original_filename — varchar2(100)
- declaration_renamed_filename — varchar2(100)
- declaration_date — date
- declaration_state — char(1)
- declaration_deldte — date
- declaration_deltype — char(1)
중고물품 테이블 (product_board)
- product_board_no — number — 기본 키 — NOT NULL
- product_board_title — varchar2(100) — NOT NULL
- seller — varchar2(30) — NOT NULL
- product_board_content — varchar2(1000)
- product_board_state — char(10)
- product_board_price — number
- original_filename — varchar2(100)
- renamed_filename — varchar2(100)
- product_board_date — date
- readcount — number
- product_board_deldate — date
- product_board_deltype — CHAR(1)
쪽지 테이블 (message)
- message_no — number — 기본 키 — NOT NULL
- message_writer — varchar2(30)
- message_reciver — VARCHAR2(30)
- message_content — varchar2(1000)
- message_read_state — char(1)default
- message_date — date
- message_deldate — date
- message_deltype — char(1)
회원 테이블 (user)
- user_id — VARCHAR2(30) — 기본 키 — NOT NULL
- user_name — VARCHAR2(20) — NOT NULL
- user_password — VARCHAR2(300) — NOT NULL
- user_phone — char(11) — NOT NULL
- user_email — VARCHAR2(50)
- user_address — VARCHAR2(100) — NOT NULL
- user_enrolldate — date
- user_deldate — date
- user_deltype — CHAR(1)