홈런볼ERD 최종_240529
테이블 (47)
CMN_CD
- cd — varchar(10) — 기본 키 — NOT NULL
- cd_type_id — varchar(3) — 기본 키 — NOT NULL
- cd_name — varchar(100) — NOT NULL
- is_active — char(1) — NOT NULL
CMN_CD_TYPE
- cd_type_id — varchar(3) — 기본 키 — NOT NULL
- cd_type_name — varchar(100) — NOT NULL
- cd_type_eng_name — varchar(100) — NOT NULL
INST_CD
- pay_meth_cd — char(1) — NOT NULL
- inst_name — varchar(20) — NOT NULL
- inst_cd — char(2)
- inst_cd_ko — varchar(10) — NOT NULL
- inst_cd_en — varchar(40) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
PAY_ERR
- pay_id — varchar(50) — 외래 키 → pay.pay_id — NOT NULL — paymentKey에 대응하는 값
- od_id — int
- trace_id — char(32) — NOT NULL
- pay_meth_cd — varchar(30) — NOT NULL
- inst_cd — char(2) — NOT NULL
- pay_err_cd — varchar(50) — NOT NULL
- err_msg_ko — varchar(100) — NOT NULL
- pay_err_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
PAY_ERR_CD
- resp_cd — char(3) — NOT NULL
- pay_err_cd — varchar(50) — NOT NULL
- err_msg_ko — varchar(100) — NOT NULL
- err_msg_en — varchar(200) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
POINT_HIST
- point_update_nuber — int — 기본 키 — NOT NULL
- point_update_date — datetime
- total_point — int
- review_point — int
- poto_review_point — int
- save_point — int
- use_point — int
RFD_HIST
- refund_id — varchar(20) — 기본 키 — NOT NULL
- pay_stat_cd — varchar(10) — NOT NULL
- refund_final_amount — int — NOT NULL
- customer_name — varchar(20) — NOT NULL
- card_type — varchar(20) — NOT NULL
- card_number_or_account_number — varchar(20) — NOT NULL
- frst_reg_dt — datetime — NOT NULL
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — datetime — NOT NULL
- last_mod_id — varchar(10) — NOT NULL
- pay_id — varchar(20) — NOT NULL
- od_id — varchar(15) — NOT NULL
- c_id — int — NOT NULL
auth_grp
- auth_grp_id — varchar(20) — 기본 키 — NOT NULL
- dept_id — varchar(20) — 외래 키 → dept.dept_id — NOT NULL
- auth_grp_name — varchar(20)
- auth_cd — char(1)
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
brd_auth
- auth_grp_id — varchar(20) — 외래 키 → auth_grp.auth_grp_id — NOT NULL
- dept_id — varchar(20) — 외래 키 → dept.dept_id — NOT NULL
- post_target_cd — varchar(20)
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
cart
- c_id — int — NOT NULL
- pd_id — varchar(12)
- pd_clsf_code — varchar(10)
- cart_cnt — int
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10)
- last_mod_dt — timestamp
- last_mod_id — varchar(10)
cust
- c_id — int — 기본 키 — NOT NULL
- c_grd_cd — tinyint — 외래 키 → cust_grd.c_grd_cd — NOT NULL
- c_stat_cd — varchar(10) — NOT NULL
- c_email — varchar(30) — NOT NULL
- c_pwd — varchar(60) — NOT NULL
- c_name — varchar(15) — NOT NULL
- c_birth — varchar(10) — NOT NULL
- c_gnd — char(1) — NOT NULL
- c_phn — varchar(12) — NOT NULL
- c_zip — varchar(6) — NOT NULL
- c_road_a — varchar(30) — NOT NULL
- c_jibun_a — varchar(30) — NOT NULL
- c_det_a — varchar(30) — NOT NULL
- c_adr_list_id — int
- sms_agr — char(1)
- email_agr — char(1)
- reg_dt — datetime
- login_dt — datetime
- tot_amt — int — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
cust_adr_list
- c_adr_list_id — int — 기본 키 — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- adr_name — varchar(10) — NOT NULL
- rcver — varchar(15) — NOT NULL
- rcver_phn — varchar(12) — NOT NULL
- rcver_zip — varchar(6) — NOT NULL
- rcver_adr — varchar(30) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
cust_grd
- c_grd_cd — tinyint — 기본 키 — NOT NULL
- grd_name — varchar(10) — NOT NULL
- grd_min_amt — int — NOT NULL
- grd_max_amt — int — NOT NULL
- grd_disc — varchar(2) — NOT NULL
- grd_stat — char(1) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
cust_hist
- c_hist_num — int — 기본 키 — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- c_cng_cd — varchar(10) — NOT NULL
- c_bf — varchar(60) — NOT NULL
- c_af — varchar(60) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
cust_wish
- c_wish_id — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- wish_stat — char(1) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
dept
- dept_id — varchar(20) — 기본 키 — NOT NULL
- dept_name — varchar(20) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
dlv
- dlv_num — int — 기본 키 — NOT NULL — 번호만 미리 채번할 수 있다
- c_id — int — 외래 키 → cust_adr_list.c_id — NOT NULL
- c_adr_list_id — int — 외래 키 → cust_adr_list.c_adr_list_id — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- carrier_co — varchar(20)
- dlv_mth — varchar(10) — // 코드로 관리 예정
- dlv_zip — varchar(6)
- pd_name — varchar(20) — 야구용품
- box_qty — tinyint — 박스수량
- dlv_snder — varchar(10) — 비회원 주문 대비
- dlv_rcver — varchar(10) — 비회원 주문 대비
- dlv_rcver_phn — varchar(12) — 비회원 주문 대비
- dlv_memo — varchar(20)
- dlv_end_dt — datetime
- dlv_stat_cd — varchar(10) — NOT NULL — DLV-0 : 배송 준비중
- dlv_taker — varchar(25) — 타인수령에 한함
- rmks_cd — varchar(10) — UNX-A/E/D/L/R/Z
- rmks_det — varchar(200) — 상세 이유
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
dlv_stat_hist
- dlv_hist_id — smallint — 기본 키 — NOT NULL — KEY : 배송번호+배송이력번호
- dlv_num — int — 외래 키 → dlv.dlv_num — NOT NULL — 번호만 미리 채번할 수 있다
- trakin_num — varchar(20) — NOT NULL — 박스 하나에 운송장 하나
- dlv_stat_cd — varchar(10) — NOT NULL
- dlv_hist_dt — datetime — NOT NULL
- dlv_loctn — varchar(20)
- dlv_dept_phn — varchar(12)
- dlv_man_phn — varchar(12)
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
emp
- emp_id — varchar(10) — 기본 키 — NOT NULL
- dept_id — varchar(20) — 외래 키 → dept.dept_id — NOT NULL
- emp_pwd — varchar(50) — NOT NULL
- emp_name — varchar(10) — NOT NULL
- emp_email — varchar(20) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
event_log
- log_id — int — 기본 키 — NOT NULL
- event_time — datetime
- error_message — text
glv_prprt
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- glv_sz — varchar(10) — NOT NULL
- glv_web_type — varchar(20) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
inq
- inq_id — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- inq_title — varchar(100) — 화면에서는 필수입력값 표시
- inq_content — varchar(1000) — 화면에서는 필수입력값 표시
- inq_phn — varchar(12)
- inq_attch_name — varchar(20)
- inq_is_sent — char(1) — NOT NULL
- inq_is_show — char(1) — NOT NULL — 비공개여부 대신 노출여부
- inq_is_cmpl — char(1) — NOT NULL
- inq_dt — datetime — NOT NULL
- inq_stat_cd — varchar(10) — NOT NULL
- inq_type_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
inq_hist
- inq_hist_id — smallint — 기본 키 — NOT NULL — KEY : 문의번호 + 문의이력번호
- inq_id — int — 외래 키 → inq.inq_id — NOT NULL
- c_id — int — 외래 키 → inq.c_id — NOT NULL
- emp_id — varchar(10) — NOT NULL
- inq_bf — varchar(1000)
- inq_af — varchar(1000) — NOT NULL
- inq_cng_item_cd — varchar(10) — NOT NULL
- inq_stat_cng_dt — datetime — NOT NULL
- inq_stat_cd — varchar(6) — NOT NULL — 상태변경 추적
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
ord
- od_id — bigint — 기본 키 — NOT NULL — KEY : 연월일 + 주문일련번호
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- od_dt — datetime — NOT NULL
- od_pd_qty — int — NOT NULL — 제품가지수
- od_tot_qty — int — NOT NULL — 주문총수량
- rtl_prc — int — NOT NULL — 소비자가격
- od_pay_amt — int — NOT NULL — 주문총금액
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
ord_claim
- od_clm_seqnum — tinyint — 기본 키 — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- c_id — int — 외래 키 → ord.c_id — NOT NULL
- od_dt_seqnum — smallint — NOT NULL
- od_clm_cd — varchar(5) — NOT NULL
- c_od_clm_dt — datetime — NOT NULL
- od_clm_canc_dt — datetime
- od_canc_cust — varchar(10)
- od_clm_cn_cd — varchar(6)
- od_clm_stat_cd — varchar(6) — NOT NULL
- pro_dt — datetime
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
ord_claim_status
- od_clm_stat_seqnum — tinyint — 기본 키 — NOT NULL
- od_clm_seqnum — tinyint — 외래 키 → ord_claim.od_clm_seqnum — NOT NULL
- od_clm_stat_cd — varchar(6) — NOT NULL
- od_clm_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
ord_det
- od_det_seqnum — smallint — 기본 키 — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- c_id — int — 외래 키 → ord.c_id — NOT NULL
- pd_id — varchar(12) — 외래 키 → stk.pd_id — NOT NULL
- pd_clsf_cd — varchar(10) — 외래 키 → stk.pd_clsf_cd — NOT NULL
- od_dt — datetime — NOT NULL
- pd_name — varchar(100) — NOT NULL — 제품명
- sls_prc — int — NOT NULL — 판매가격
- od_qty — int — NOT NULL — 제품주문수량
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
- od_stat_cd — varchar(6) — NOT NULL — 주문상태코드
ord_hist
- od_hist_seqnum — int — 기본 키 — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- c_id — int — 외래 키 → ord.c_id — NOT NULL
- od_cng_item_cd — varchar(10) — NOT NULL — 변경항목코드
- od_bf — varchar(100) — 변경전
- od_af — varchar(100) — NOT NULL — 변경후
- od_cng_dt — datetime — NOT NULL — 변경일자
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
ord_stat
- od_stat_seqnum — int — 기본 키 — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- c_id — int — 외래 키 → ord.c_id — NOT NULL
- od_stat_cd — varchar(6) — NOT NULL — 주문상태코드
- od_stat_cng_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
pay
- pay_id — varchar(50) — 기본 키 — NOT NULL — paymentKey에 대응하는 값
- pay_seqnum — int — 기본 키 — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- od_id — bigint — 외래 키 → ord.od_id — NOT NULL — KEY : 연월일 + 주문일련번호
- trace_id — char(32) — NOT NULL — PG사 로그 검색에 필요한 값
- disc_amt — int
- od_pay_amt — int — NOT NULL
- pay_final_amt — int — NOT NULL
- pay_stat_cd — varchar(10) — NOT NULL — 카드결제 시, 결제상태코드는 결제완료(05)
- pay_dt — datetime
- pay_meth_cd — varchar(30)
- pay_aprv_stat — varchar(10) — NOT NULL — 인증 이후 결제요청 승인 상태(DONE)
- pay_aprv_num — varchar(10) — 테스트값(00000000)
- pay_aprv_dt — datetime
- pay_resp_cd — varchar(10) — NOT NULL — 인증 응답코드 성공(200)
- pay_canc_amt — int
- pay_canc_dt — datetime
- c_name — varchar(15) — 고객테이블과 이름, 타입맞춰야함
- issuer_cd — char(2) — NOT NULL — INST_CD 참조
- acquier_cd — char(2) — NOT NULL — INST_CD 참조
- trans_type — varchar(20) — NOT NULL
- mth_instlmt — tinyint — 일시불은 0개월
- card_num — varchar(20)
- bank_name — varchar(20)
- acct_num — varchar(20)
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
- pay_od_name — varchar(100) — NOT NULL — 1번 상품명 + 외 (n-1)건
pd_hist
- pd_hist_seqnum — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- pd_cntn_cng_item_cd — varchar(10) — NOT NULL
- pd_bf — varchar(100) — NOT NULL
- pd_af — varchar(100) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
pd_stat_hist
- pd_stat_hist_seqnum — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- pd_stat_hist_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
post
- post_id — int — 기본 키 — NOT NULL
- emp_id — varchar(10) — 외래 키 → emp.emp_id — NOT NULL
- post_cntn — varchar(3000) — NOT NULL
- post_dt — datetime — NOT NULL
- post_attch_name — varchar(20)
- post_veiw_cnt — int — NOT NULL
- post_score — tinyint(1) — NOT NULL — 범위 1~5
- post_is_show — char(1) — NOT NULL
- post_type_cd — varchar(10) — NOT NULL
- post_target_cd — varchar(10) — NOT NULL — BRD-00 : 임시저장소
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
prc_cng_hist
- prc_cng_seqnum — int — 기본 키 — NOT NULL
- pd_clsf_cd — varchar(10) — 외래 키 → stk.pd_clsf_cd — NOT NULL
- pd_id — varchar(12) — 외래 키 → stk.pd_id — NOT NULL
- cng_prc — int — NOT NULL
- prc_strt_dt — datetime — NOT NULL
- prc_end_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
prd
- pd_id — varchar(12) — 기본 키 — NOT NULL
- pd_name — varchar(100) — NOT NULL
- mdl_name — varchar(100) — NOT NULL
- qlt_cd — varchar(10) — NOT NULL
- ctg — varchar(40)
- mn_img_fn — varchar(1000) — NOT NULL
- det_img_fn — varchar(1000) — NOT NULL
- pd_ad_cmt — varchar(1000)
- pd_smr_dsc — varchar(200) — NOT NULL
- pd_det_dsc — varchar(5000) — NOT NULL
- min_od_qty — int — NOT NULL
- max_od_qty — int
- pd_is_show — char(1) — NOT NULL
- sls_strt_dt — datetime — NOT NULL
- pd_mnf_date — varchar(8) — NOT NULL — yyyymmdd
- og_pd_num — varchar(100) — NOT NULL
- origin — varchar(10) — NOT NULL
- mfr — varchar(10) — NOT NULL
- srs_id — varchar(1000)
- age_grp_cd — varchar(10) — NOT NULL
- player_name — varchar(50)
- mtrl — varchar(100) — NOT NULL
- season — varchar(10) — NOT NULL
- wgh — int — 단위: 그램(g)
- clr_cd — varchar(10) — NOT NULL
- hit_cnt — int — NOT NULL
- rvw_cnt — int — NOT NULL
- wish_cnt — int — NOT NULL
- pd_chr_cd — varchar(10) — 신상품, 스테디셀러, hot
- sprt_type_cd — varchar(10) — NOT NULL
- pd_type_cd — varchar(10) — NOT NULL
- pd_type_det_cd — varchar(10) — NOT NULL
- brd_cd — varchar(10) — NOT NULL
- pd_stat_hist_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
pur_bnf
- pur_bnf_cd — varchar(10) — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- pur_is_bnf — char(1) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
pur_bnf_hist
- pur_bnf_hist_seqnum — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → pur_bnf.pd_id — NOT NULL
- pur_bnf_cd — varchar(10) — 외래 키 → pur_bnf.pur_bnf_cd — NOT NULL
- pur_is_bnf_bf — char(1) — NOT NULL
- pur_is_bnf_af — char(1) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
revw
- revw_id — int — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- c_id — int — 외래 키 → cust.c_id — NOT NULL
- revw_cntn — varchar(3000) — 화면에서는 필수입력값 표시
- revw_attch_name — varchar(20)
- revw_dt — datetime — NOT NULL
- revw_score — tinyint(1) — NOT NULL — 범위 1~5
- revw_is_reported — char(1) — NOT NULL
- revw_is_show — char(1) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
revw_hist
- revw_hist_id — smallint — 기본 키 — NOT NULL — KEY : 리뷰번호+이력번호
- revw_id — int — 기본 키 — NOT NULL — KEY : 리뷰번호+이력번호
- c_id — int — NOT NULL — 조회에 용이한 중복컬럼
- revw_cng_item — varchar(10) — NOT NULL
- revw_bf — varchar(3000)
- revw_af — varchar(3000) — NOT NULL
- revw_cng_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
revw_repl
- revw_repl_id — smallint — 기본 키 — NOT NULL — KEY : 리뷰번호+댓글번호
- revw_id — int — 외래 키 → revw.revw_id — NOT NULL
- pd_id — varchar(12) — 외래 키 → revw.pd_id — NOT NULL
- c_id — int — 외래 키 → revw.c_id — NOT NULL
- c_nane — varchar(15) — NOT NULL
- revw_repl_cntn — varchar(1000) — 화면에서는 필수입력값 표시
- revw_repl_dt — datetime — NOT NULL
- revw_repl_ref — smallint — 대댓글만 갖는 값
- revw_repl_type_cd — varchar(10) — 추후에 구분을 위한 예약컬럼
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
revw_repl_hist
- revw_repl_hist_id — smallint — 기본 키 — NOT NULL — KEY : 리뷰번호+댓글번호+이력번호
- revw_repl_id — smallint — 외래 키 → revw_repl.revw_repl_id — NOT NULL — KEY : 리뷰번호+댓글번호
- revw_id — int — 외래 키 → revw_repl.revw_id — NOT NULL
- c_id — int — 외래 키 → revw_repl.c_id — NOT NULL
- revw_repl_cng_item_cd — varchar(10) — NOT NULL
- revw_repl_bf — varchar(1000)
- revw_repl_af — varchar(1000) — NOT NULL
- revw_repl_cng_dt — datetime — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
rltd_pd
- rltd_pd_seqnum — tinyint — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- rltd_pd_id — varchar(12) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
rstk_noti
- rstk_noti — varchar(30) — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → stk.pd_id — NOT NULL
- pd_clsf_cd — varchar(10) — 외래 키 → stk.pd_clsf_cd — NOT NULL
- phn — varchar(12)
- resp_err_cd — varchar(5)
- frst_reg_dt — timestamp
- frst_mod_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
size_list
- size_list_id — int — 기본 키 — NOT NULL
- pd_type_cd — varchar(10) — NOT NULL
- pd_clsf_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
- display_order — int
stk
- pd_clsf_cd — varchar(10) — 기본 키 — NOT NULL
- pd_id — varchar(12) — 외래 키 → prd.pd_id — NOT NULL
- pd_name — varchar(100) — NOT NULL
- nml_stk_qty — int — NOT NULL
- rt_stk_qty — int — NOT NULL
- rgn_stk_qty — int — NOT NULL
- urgn_stk_qty — int — NOT NULL
- sfty_stk_qty — int — NOT NULL
- odpmt_stk — int — 정품재고수량+반품재고수량+재생가능수량
- pur_dt — varchar(8) — NOT NULL
- rcpt_dt — varchar(8) — NOT NULL
- rcpt_cp — varchar(20) — NOT NULL
- rcpt_prc — int — NOT NULL
- rtl_prc — int — NOT NULL
- sls_prc — int — NOT NULL
- stk_plc_cd — varchar(10) — 처음 주문할 때 재고 위치가 안 정해져 있을 수도 있다.
- stk_stat_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
stk_hist
- stk_hist_seqnum — int — 기본 키 — NOT NULL
- pd_clsf_cd — varchar(10) — 외래 키 → stk.pd_clsf_cd — NOT NULL
- pd_id — varchar(12) — 외래 키 → stk.pd_id — NOT NULL
- stk_adj_item_cd — varchar(10) — NOT NULL
- stk_af — int — NOT NULL
- stk_hist_cng_dsc — varchar(100) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL
stk_stat
- stk_stat_seqnum — int — 기본 키 — NOT NULL
- pd_clsf_cd — varchar(10) — 외래 키 → stk.pd_clsf_cd — NOT NULL
- pd_id — varchar(12) — 외래 키 → stk.pd_id — NOT NULL
- stk_stat_cd — varchar(10) — NOT NULL
- frst_reg_dt — timestamp
- frst_reg_id — varchar(10) — NOT NULL
- last_mod_dt — timestamp
- last_mod_id — varchar(10) — NOT NULL