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)