확인작업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