확인작업2

테이블 (8)

Cart

  • c_no — varchar2 — 기본 키 — NOT NULL
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • p_no — varchar2 — 외래 키 → Product.p_no — NOT NULL
  • c_cnt — number

Product

  • p_no — varchar2 — 기본 키 — NOT NULL
  • p_name — varchar2
  • p_price — number
  • p_cnt — number
  • p_color — varchar2
  • p_size — varchar2
  • p_filesrc — varchar2
  • p_date — date
  • p_category — varchar2
  • p_info — varchar2

cancle_member

  • om_cntnum — varchar2 — 외래 키 → order_member.om_cntnum
  • m_id — varchar2 — 외래 키 → order_member.m_id — NOT NULL
  • p_no — varchar2 — 외래 키 → order_member.p_no — NOT NULL
  • om_date — date
  • om_num — varchar2
  • p_price — number
  • om_state — varchar2
  • c_date — date
  • c_reason — varchar2

member

  • m_id — varchar2 — 기본 키 — NOT NULL
  • m_pw — varchar2
  • m_name — varchar2
  • m_tel — number
  • m_name2 — varchar2
  • m_email — varchar2
  • m_grade — varchar2
  • m_age — number
  • m_gender — varchar2
  • m_cash — number
  • m_filesrc — varchar2

order_delivery

  • od_num — varchar2 — 기본 키
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • addr1 — varchar2
  • addr2 — varchar2
  • addr3 — varchar2
  • receipt_name — varchar2
  • receipt_phone — varchar2
  • od_date — date

order_member

  • om_cntnum — varchar2 — 기본 키
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • p_no — varchar2 — 외래 키 → Product.p_no — NOT NULL
  • om_num — varchar2 — NOT NULL
  • p_color — varchar2
  • p_size — varchar2
  • u_cnt — number
  • om_date — date
  • om_pay — varchar2
  • p_price — number
  • om_state — varchar2
  • om_cancle — varchar2
  • om_cdate — date
  • om_delcancle — varchar2

qna_member

  • q_mno — number — 기본 키 — NOT NULL
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • q_mtitle — varchar2
  • q_mcontent — varchar2
  • q_mreply — varchar2
  • q_mid — varchar2
  • q_mynn — char(1)
  • q_mdate — date
  • q_mgroup — number
  • q_mstep — number
  • q_mindent — number

review

  • r_no — number — 기본 키 — NOT NULL
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • r_title — varchar2
  • r_content — varchar2
  • r_id — varchar2
  • r_retitle — varchar2
  • r_recontent — varchar2
  • r_ynn — char(1)
  • r_date — date
  • r_group — number
  • r_step — number
  • r_indent — number
  • r_filesrc — varchar2