파이날프로젝트제출용

테이블 (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