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