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)