파이날프로젝트제출용
테이블 (28)
MEMBER
- m_no — NUMBER — 기본 키
- m_email — varchar2(150) — NOT NULL
- m_pwd — varchar2(250) — NOT NULL
- m_name — varchar2(50) — NOT NULL
- m_nickname — varchar2 — NOT NULL
- m_phone — varchar2(50) — NOT NULL
- m_age — number — NOT NULL
- m_gender — varchar2(20)
- 여자)) — NOT — NOT NULL
- m_address — varchar2(300) — NOT NULL
- m_detail_address — varchar2(150) — NOT NULL
- m_remove_date — DATE
- m_in_date — DATE — NOT NULL
- m_type — NUMBER
- m_recipe_count — NUMBER
- m_subscriber — NUMBER
- m_purchase_amount — NUMBER
- m_upload_path — varchar2(255)
- m_upload_name — varchar2(255)
- m_upload_origin — varchar2(255)
SEARCh
- s_no — NUMBER — 기본 키
- s_searchTitle — varchar2(150) — NOT NULL
- s_searchCount — NUMBER — NOT NULL
adimnAnswer
- aa_no — NUMBER — 기본 키
- a_no — NUMBER — 외래 키 → admin.a_no — NOT NULL
- i_no (i_no2) — NUMBER — 외래 키 → inquiry.i_no
- aa_reply — varchar2(200) — NOT NULL
- aa_in_date — DATE — NOT NULL
admin
- a_no — NUMBER — 기본 키
- a_id — varchar2(150) — NOT NULL
- a_pwd — varchar2(150) — NOT NULL
- a_name — varchar2(50) — NOT NULL
- a_authority — varchar2(150)
- Field
- m_no — NUMBER — 외래 키 → MEMBER.m_no
announcement
- ac_no — NUMBER — 기본 키
- a_no — NUMBER — 외래 키 → admin.a_no
- ac_title — varchar2(150) — NOT NULL
- ac_contents — varchar2(300) — NOT NULL
- ac_file_path — varchar2(250)
- ac_file_name — varchar2(250)
- ac_file_origin — varchar2(250)
- ac_in_date — DATE — NOT NULL
- ac_delete_date — DATE
- ac_update_date — DATE
- ac_views — NUMBER — NOT NULL
- Field
chatMessage
- cm_no — NUMBER — 기본 키
- cr_no — NUMBER — 외래 키 → chatRoom.cr_no — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- cm_message — varchar2(2000) — NOT NULL
- cm_send_time — DATE
chatRoom
- cr_no — NUMBER — 기본 키
- first_m_no — NUMBER — 외래 키 → MEMBER.m_no
- second_m_no — NUMBER — 외래 키 → MEMBER.m_no
- cr_start_date — DATE — NOT NULL
- cr_end_date — DATE
delivery
- d_no — NUMBER — 기본 키
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- d_name — varchar2(50) — NOT NULL
- d_postal_address — varchar2(255) — NOT NULL
- d_address — varchar2(200) — NOT NULL
- d_detailAdress — varchar2(150) — NOT NULL
- d_phone — varchar2(150) — NOT NULL
- d_request — varchar2(150) — NOT NULL
- d_defaultDelivery — NUMBER — NOT NULL
eventList
- e_no — NUMBER — 기본 키
- a_no — NUMBER — 외래 키 → admin.a_no
- e_title — varchar2(150) — NOT NULL
- e_contents — varchar2(150) — NOT NULL
- e_file_path — varchar2(250)
- e_file_name — varchar2(250)
- e_file_origin — varchar2(250)
- e_in_date — DATE — NOT NULL
- e_delete_date — DATE
- e_update_date — DATE
- e_views — NUMBER — NOT NULL
favoriteRecipe
- fr_no — NUMBER — 기본 키
- fr_scrap — DATE — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
findMate
- f_no — NUMBER — 기본 키
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- f_writer — varchar2(150) — NOT NULL
- f_title — varchar2(250) — NOT NULL
- f_introduction — varchar2(200) — NOT NULL
- f_food — varchar2(150) — NOT NULL
- f_time — varchar2(150) — NOT NULL
- f_person_number — NUMBER — NOT NULL
- f_age_limit — NUMBER — NOT NULL
- f_contents — varchar2(500) — NOT NULL
- f_in_date — DATE — NOT NULL
- f_delete_date — DATE
- f_complete_check — varchar2(50)
- f_views — NUMBER — NOT NULL
- f_upload_path — varchar2(255)
- f_upload_name — varchar2(255)
- f_upload_origin — varchar2(255)
foodMateComment
- fc_no — NUMBER — 기본 키
- fc_comment — varchar2(300) — NOT NULL — archar2(300) NOT NUL
- fc_writer — varchar2(150) — NOT NULL
- fc_in_date — DATE — NOT NULL
- f_no — NUMBER — 외래 키 → findMate.f_no — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
freeList
- fl_no — NUMBER — 기본 키
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- fl_title — varchar2(150) — NOT NULL
- fl_contents — varchar2(250) — NOT NULL
- fl_writer — varchar2(150) — NOT NULL
- fl_file_path — varchar2(250)
- fl_file_name — varchar2(250)
- fl_file_origin — varchar2(250)
- fl_in_date — DATE — NOT NULL
- fl_delete_date — DATE
- fl_update_date — DATE
- fl_views — NUMBER — NOT NULL
freeListComment
- fc_no — NUMBER — 기본 키
- fc_comment — varchar2(300) — NOT NULL — archar2(300) NOT NUL
- fc_writer — varchar2(150) — NOT NULL
- fc_in_date — DATE — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- fl_no (fl_no2) — NUMBER — 외래 키 → freeList.fl_no
goods
- g_no — NUMBER — 기본 키
- g_name — varchar2(150) — NOT NULL
- g_file_path — varchar2(255)
- g_file_name — varchar2(150)
- G_ORIGIN_NAME — varchar(150)
- g_introduce — varchar2(500)
- g_regular_price — NUMBER — NOT NULL
- g_price — NUMBER — NOT NULL
- G_DCRATE — NUMBER — NOT NULL
- g_in_date — DATE — NOT NULL
- g_stock — NUMBER — NOT NULL
- g_delete_check — varchar2(150)
goodsPhotos
- gp_no — NUMBER — 기본 키
- g_no — NUMBER — 외래 키 → goods.g_no — NOT NULL
- gp_file_path — varchar2(255)
- gp_file_name — varchar2(150)
- gp_ORIGIN_NAME — varchar(150)
- gp_type — NUMBER — NOT NULL
inquiry
- i_no — NUMBER — 기본 키
- m_no — NUMBER — 외래 키 → MEMBER.m_no
- g_no — NUMBER — 외래 키 → goods.g_no
- i_title — varchar2(150) — NOT NULL
- i_contents — varchar2(300) — NOT NULL
- i_in_date — DATE — NOT NULL
- i_file_path — varchar2(255)
- i_file_name — varchar2(150)
orderDetail
- od_no — NUMBER — 기본 키
- od_price — NUMBER — NOT NULL
- od_count — NUMBER — NOT NULL
- o_no — NUMBER — 외래 키 → orders.o_no — NOT NULL
- g_no — NUMBER — 외래 키 → goods.g_no — NOT NULL
orders
- o_no — NUMBER — 기본 키
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- o_recipient_name — varchar2(100) — NOT NULL
- o_postal_address — varchar2(255) — NOT NULL
- o_address — varchar2(255) — NOT NULL
- o_detailed_address — varchar2(155) — NOT NULL
- o_recipient_phone — varchar2(155) — NOT NULL
- o_order_date — DATE — NOT NULL
- o_payment_amount — NUMBER — NOT NULL
- o_order_status — varchar2(50)
- o_status_change_date — DATE
recentRecipe
- rr_no — NUMBER — 기본 키
- rr_in_date — DATE — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
recipe
- r_no — NUMBER — 기본 키
- r_writer — varchar2(100) — NOT NULL
- r_title — varchar2(200) — NOT NULL
- r_introduction — varchar2(300) — NOT NULL
- r_food_category — varchar2(200) — NOT NULL
- r_situation_category — varchar2(50) — NOT NULL
- r_how_category — varchar2(50) — NOT NULL
- r_ingredient_category — varchar2(50) — NOT NULL
- r_person — varchar2(50) — NOT NULL
- r_time — varchar2(50) — NOT NULL
- r_difficulty — varchar2(50) — NOT NULL
- r_tip — varchar2(300) — NOT NULL
- r_tag — varchar2(300)
- r_views — NUMBER — NOT NULL
- r_in_date — DATE — NOT NULL
- r_update_date — DATE
- r_saveCount — NUMBER
- r_upload_path — varchar2(255)
- r_upload_name — varchar2(255)
- r_upload_origin — varchar2(255)
- m_no — number — NOT NULL
recipeComment
- rc_no — NUMBER — 기본 키
- rc_comment — varchar2(300) — NOT NULL — archar2(300) NOT NUL
- rc_in_date — DATE — NOT NULL
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
recipeIngredient
- ri_no — NUMBER — 기본 키
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
- ri_ingredient — varchar2(300) — NOT NULL
- ri_ingredient_weight — varchar2(500) — NOT NULL
recipeSeasoning
- rn_no — NUMBER — 기본 키
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
- rn_seasoning — varchar2(300)
- rn_weight — varchar2(300)
recipeSequence
- rs_no — NUMBER — 기본 키
- r_no — NUMBER — 외래 키 → recipe.r_no — NOT NULL
- rs_sequence — varchar2(500) — NOT NULL
recipeSequencePhoto
- rp_no — NUMBER — 기본 키
- rs_no — NUMBER — 외래 키 → recipeSequence.rs_no — NOT NULL
- rp_file_path — varchar2(500)
- rp_file_name — varchar2(300)
- rp_file_origin — varchar2(500)
review
- rv_no — NUMBER
- rv_title — varchar2(150) — NOT NULL
- rv_contents — varchar2(300) — NOT NULL
- rv_in_date — DATE — NOT NULL
- rv_file_path — varchar2(255)
- rv_file_name — varchar2(150)
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- g_no — NUMBER — 외래 키 → goods.g_no — NOT NULL
- i_title — varchar2(150) — NOT NULL
- i_contents — varchar2(300) — NOT NULL
- i_in_date — DATE — NOT NULL
- i_file_path — varchar2(255)
- i_file_name — varchar2(150)
- m_no — NUMBER — NOT NULL
- g_no — NUMBER — NOT NULL
shoppingCart
- sc_no — NUMBER — 기본 키
- sc_price — NUMBER — NOT NULL
- sc_count — NUMBER — NOT NULL
- m_no — NUMBER — 외래 키 → MEMBER.m_no — NOT NULL
- g_no — NUMBER — 외래 키 → goods.g_no — NOT NULL