farmocean

Tables (12)

BANNER (배너관리)

  • Key (IDX) — number(4) — Primary key — NOT NULL
  • Field (CATE) — varchar2(20)
  • Field2 (TARGET) — number(1)
  • Field3 (TITLE) — varchar2(50)
  • Field4 (LINK) — varchar2(300)
  • Field5 (REGDATE) — date
  • Field6 (FILENAME) — varchar2(300)
  • Field7 (USE) — number(1)

MEMBER_FAULTY (회원신고)

  • Key (FAULTY_IDX) — number(12) — Primary key — NOT NULL
  • Field (REPORT_MAMNER_ID) — varchar2(40)
  • Field2 (FAULTY_MAMNER_ID) — varchar2(40)
  • Field3 (FAULTY_MEMO) — varchar2(100)
  • Field4 (FAULTY_IN_DATE) — date

PROD_BIDS (찜)

  • Key (bids_idx) — varchar2(10) — Primary key — NOT NULL
  • Key (bids_prod_idx) — number(12) — Foreign key → prod_detail.Key — NOT NULL
  • Key (bids_member_id) — varchar2(30) — Foreign key → member.Key — NOT NULL
  • Field3 (bids_in_date) — date

PROD_BUYLIST (상품구매신청목록)

  • BUY_IDX — NUMBER(12,0)
  • PROD_IDX — NUMBER(12,0)
  • SELL_ID — VARCHAR2(200 BYTE)
  • BUY_ID — VARCHAR2(200 BYTE)
  • POST_CODE — VARCHAR2(10 BYTE)
  • ROAD_ADDRESS — VARCHAR2(200 BYTE)
  • JIBUN_ADDRESS — VARCHAR2(200 BYTE)
  • DETAIL_ADDRESS — VARCHAR2(200 BYTE)
  • EXTRAA_DDRESS — VARCHAR2(200 BYTE)
  • STATE — NUMBER(2,0)
  • REG_DATE — DATE
  • UPT_DATE — DATE
  • UPT_ID — VARCHAR2(200 BYTE)

PROD_REVIEW

  • REVIEW_IDX — NUMBER(8,0) — Primary key
  • PROD_IDX — NUMBER(8,0)
  • REVIEW_CONTENT — CLOB
  • REVIEW_DATE — TIMESTAMP
  • MEMBER_ID — VARCHAR2(30 BYTE)
  • REVIEW_STARNUM — NUMBER(2,0)
  • BUY_IDX — NUMBER(12,0)

board_cate_info (게시판 종류)

  • Key (cate_idx) — number(4) — Primary key — NOT NULL
  • Field (cate_name) — varchar2(20)
  • Field2 (cate_writer) — varchar2(30)
  • Field3 (cate_in_date) — date
  • Field4 (cate_use) — number(1)

board_notice (공지사항)

  • Key (board_idx) — number(8) — Primary key — NOT NULL
  • Field (board_cate) — number(4)
  • Field2 (board_header) — number(4)
  • Field3 (board_title) — varchar2(200)
  • Field4 (board_memo) — CLOB
  • Field5 (board_count) — number(8)
  • Field6 (board_writer) — varchar2(30)
  • Field7 (board_in_date) — date
  • Field8 (board_mod_writer) — varchar2(30)
  • Field9 (board_mod_date) — date

follow (팔로우)

  • Key (follow_id) — number(12) — Primary key — NOT NULL
  • Field (follower_id) — varchar2(10)
  • Field2 (followee_id) — varchar2(10)

member (회원정보)

  • Key (MEMBER_ID) — varchar2(30) — Primary key — NOT NULL
  • Field (MEMBER_PW) — varchar2(30)
  • Field2 (MEMBER_NAME) — varchar2(30)
  • Field3 (MEMBER_NICKNAME) — varchar2(60)
  • Field4 (MEMBER_POINT) — number(10)
  • Field5 (MEMBER_EMAIL) — varchar2(30)
  • Field6 (MEMBER_PHONENUM) — varchar2(30)
  • Field7 (MEMBER_ACCOUNTNUM) — varchar2(60)
  • Field8 (MEMBER_ADDRESS) — varchar2(100)
  • Field9 (MEMBER_ACCOUNT_STATUS) — number(1)
  • Field10 (MEMBER_TYPE) — varchar2(10)
  • Field11 (MEMBER_IMAGE) — varchar2(200)

messageBox (쪽지함)

  • Key (message_id) — varchar2(10) — Primary key — NOT NULL
  • Field (sender_id) — varchar2(20)
  • Field2 (recipient_id) — varchar2(20)
  • Field3 (message_title) — varchar2(20)
  • Field4 (message_contents) — varchar2(20)
  • Field5 (message_date) — date
  • Field6 (message_check) — CHAR(3)

prod_comment (상품 댓글)

  • Key (comment_idx) — number(8) — Primary key — NOT NULL
  • Key (prod_idx) — number(8) — Foreign key → prod_detail.Key — NOT NULL
  • Key (MEMBER_ID) — varchar2(30) — Foreign key → prod_detail.Key — NOT NULL
  • Field (comment_writer) — varchar2(20)
  • Field2 (comment_content) — CLOB
  • Field (comment_date) — TIMESTAMP

prod_detail (상품)

  • Key (prod_idx) — number(8) — Primary key — NOT NULL
  • Key (member_id) — varchar2(30) — Foreign key → member.Key — NOT NULL
  • Field (prod_name) — varchar2(20)
  • Field2 (prod_cate) — varchar2(20)
  • Field4 (prod_info) — CLOB
  • Field5 (prod_price) — varchar2(20)
  • Field7 (prod_sell) — varchar2(50)
  • Field8 (prod_sell_deadline) — TIMESTAMP