확인작업1

테이블 (9)

Cart

  • c_no — varchar2 — 기본 키 — NOT NULL
  • p_no — varchar2 — 외래 키 → Product.p_no — NOT NULL
  • m_id — varchar2
  • 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 (상품주문번호(20230301seq)) — varchar2 — 외래 키 → order_member_detail.om_cntnum
  • 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 (배송번호(D20230301seq)) — varchar2 — 기본 키
  • om_num (주문번호) — varchar2 — 외래 키 → order_member.om_num — NOT NULL
  • addr1 — varchar2
  • addr2 — varchar2
  • addr3 — varchar2
  • receipt_name (receipt_name(수령인이름)) — varchar2
  • receipt_phone (receipt_phone(수령인전화)) — varchar2
  • od_date — date

order_member

  • om_num (주문번호(20230301153651아이디)) — varchar2 — 기본 키 — NOT NULL
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • om_date — date
  • om_pay (om_pay(주문서결제총액)) — varchar2

order_member_detail (CopyOforder_member)

  • om_cntnum (상품주문번호(20230301seq)) — varchar2 — 기본 키
  • om_num (주문번호(20230301153651아이디)) — varchar2 — 외래 키 → order_member.om_num — NOT NULL
  • p_no (p_no(상품번호)) — varchar2 — 외래 키 → Product.p_no — NOT NULL
  • u_cnt (u_cnt(상품주문수량)) — number
  • u_pricetot (u_pricetot(상품주문총액)) — number
  • om_state — varchar2
  • om_cancle — varchar2
  • om_cdate — date
  • om_delcancle — varchar2

qna_member

  • q_mno — number — 기본 키 — NOT NULL
  • q_mtitle — varchar2
  • q_mcontent — varchar2
  • q_mreply — varchar2
  • m_id — varchar2 — 외래 키 → member.m_id — NOT NULL
  • 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
  • om_cntnum (상품주문번호(20230301seq)) — varchar2 — 외래 키 → order_member_detail.om_cntnum
  • 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