test

Tables (22)

Conversation

  • conver_no — number(5) — Primary key — NOT NULL
  • room_no — NUMBER(3) — Foreign key → Room_ppl.room_no — NOT NULL
  • mem__nickname — VARCHAR2(50) — Foreign key → Room_ppl.mem__nickname — NOT NULL
  • conver_text — VARCHAR2(200)
  • conver_time — VARCHAR2(50)
  • isRead — char(1)

Conversation_Info

  • conver_no — number(5) — Primary key — NOT NULL
  • room_no — NUMBER(3) — Foreign key → Room_ppl.room_no — NOT NULL
  • price — number(6)
  • conver_time — VARCHAR2(50)
  • rider_to — char(1)
  • rider_from — char(1)

Room_ppl

  • room_no — NUMBER(3) — Primary key — NOT NULL
  • mem__nickname — varchar2(30) — Foreign key → member.mem_email — NOT NULL

bank_mem

  • account_no — number(13) — Primary key — NOT NULL
  • bmem_name — varchar2(20)
  • bmem_deposit — number(7)
  • account_pw — number(4)
  • mem_IDnum — number(13)

board_img

  • bi_no — number(7) — Primary key — NOT NULL
  • bi_file — varchar2(100)
  • bm_no — number(6) — NOT NULL

board_like

  • bm_no — number(6) — Foreign key → board_master.bm_no — NOT NULL
  • like10s — number(3)
  • like20s — number(3)
  • like30s — number(3)
  • like40s — number(3)
  • like50s — number(3)
  • like60s — number(3)

board_master

  • bm_no — number(6) — Primary key — NOT NULL
  • bm_title — varchar2(100)
  • bm_hit — number(3)
  • bm_date — date
  • bm_like — number(3)
  • bm_content — varchar2(200)
  • bm_price — number(9)
  • bm_isSold — char(1)
  • mem__nickname — VARCHAR2(30) — NOT NULL
  • category_name — VARCHAR2(50) — NOT NULL

category

  • category_name — VARCHAR2(50) — Primary key — NOT NULL

coin

  • mem_email — VARCHAR2(50) — Foreign key → member.mem_email — NOT NULL
  • coin_remain — number(7)

coin_trans

  • trans_no — number(5) — Primary key — NOT NULL
  • mem_email — VARCHAR2(50) — NOT NULL
  • trans_date — date
  • trans_content — varchar2(200)
  • trans_price — number(6)
  • trans_remain — number(6)
  • trans_io — char(1)

comment

  • comment_no — number(3) — Primary key — NOT NULL
  • comment_msg — varchar2(200)
  • mem__nickname — VARCHAR2(30) — NOT NULL
  • comment_date — date
  • bm_no — number(6) — NOT NULL

comment_sub

  • comment_sub_no — number(3) — Primary key — NOT NULL
  • comment_no — number(3) — NOT NULL
  • mem__nickname — VARCHAR2(30) — NOT NULL
  • comment_sub_msg — varchar2(200)
  • comment_sub_date — date

errand

  • errand_no — number(5)
  • errand_item — varchar2(50)
  • errand_date — date — NOT NULL
  • errand_price — number(6)
  • errand_real_price — number(6)
  • errand_errand — number(6)
  • errand_content — varchar2(200)
  • errand_hasRider — char(1)
  • mem_nickname_do — VARCHAR2(30) — NOT NULL
  • mem_nickname_get — VARCHAR2(30) — NOT NULL

join_report__board

  • position — char(1) — Primary key — NOT NULL
  • report_no — number(6) — Foreign key → report_board.report_no — NOT NULL
  • mem_email — VARCHAR2(50) — NOT NULL

join_report_mem

  • position — char(1) — Primary key — NOT NULL
  • report_no — number(3) — Foreign key → report_mem.report_no — NOT NULL
  • mem_email — VARCHAR2(50) — NOT NULL

member

  • mem_email — VARCHAR2(50) — Primary key — NOT NULL
  • mem_img — varchar2(100)
  • mem__nickname — varchar2(30)
  • mem_pw — varchar2(80)
  • mem_gender — char(1)
  • mem_age — number(2)
  • mem_create_date — date
  • isSocial — char(1)
  • mem_active — char(1)
  • pay_pw — Varchar2(80)

my_like

  • bm_no — number(6) — Foreign key → board_master.bm_no — NOT NULL
  • mem_email — VARCHAR2(50) — Foreign key → member.mem_email — NOT NULL

report_board

  • report_no — number(6) — Primary key — NOT NULL
  • report_msg — varchar2(200)
  • report_date — date
  • bm_no — number(6) — NOT NULL
  • report_type — varchar2(100) — NOT NULL

report_board_type

  • report_type — varchar2(100) — Primary key — NOT NULL

report_mem

  • report_no — number(3) — Primary key — NOT NULL
  • report_msg — varchar2(200)
  • report_date — date
  • report_type — varchar2(100) — NOT NULL

report_mem_type

  • report_type — varchar2(100) — Primary key — NOT NULL

search_words

  • keyword — varchar2(50) — Primary key — NOT NULL
  • word_total — number(7)
  • word_day — number(5)