KEP ERD

Tables (52)

Untitled13

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255) — EI, NS, FT, PJ
  • Field3 — VARCHAR(255)

Untitled14

  • Key2 — VARCHAR(255) — Primary key — NOT NULL
  • Key — VARCHAR(255) — Foreign key → Untitled13.Key — NOT NULL
  • Field2 — VARCHAR(255) — E, I, N, S, F, T, P, J
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)

Untitled15

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Key2 — VARCHAR(255) — Foreign key → Untitled13.Key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)
  • Field7 — VARCHAR(255)
  • Field8 — VARCHAR(255)
  • Field9 — VARCHAR(255)
  • Field10 — VARCHAR(255)

Untitled27

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Key2 — VARCHAR(255) — Foreign key → tb_member.member_id — NOT NULL
  • Field — VARCHAR(255) — 회원가입/후기/이벤트
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255) — 2023-06-01
  • Field4 — VARCHAR(255) — 2023-06-30
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)

Untitled28

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Key2 — VARCHAR(255) — Foreign key → Untitled27.Key — NOT NULL
  • Key22 — VARCHAR(255) — Foreign key → Untitled27.Key2 — NOT NULL
  • Field — VARCHAR(255) — 차감/복원
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)

store

  • store_id — int8 — Primary key — NOT NULL
  • id — varchar(20)
  • password — varchar(80)
  • store_status_code — bpchar(20) — NOT NULL — 승인/대기
  • store_name — varchar(20)
  • representative_name — varchar(20)
  • tel_number — varchar(40)
  • mobile_number — varchar(20)
  • email — varchar(100)
  • hcode — varchar(10)
  • bcode — varchar(10)
  • region_depth_name1 — vharchar(20)
  • region_depth_name2 — varchar(20)
  • region_depth_name3 — varchar(20)
  • post_number — varchar(6)
  • road_address — varchar(100)
  • road_address_detail — varchar(100)
  • business_number — varchar(13)
  • bank_name — varchar(20)
  • account_number — varchar(30)
  • account_holder_name — varchar(20)

tb_books

  • books_id — int8 — Primary key — NOT NULL
  • book_name — varchar(100) — NOT NULL
  • author_name — varchar(20) — NOT NULL
  • publisher_name — varchar(20) — NOT NULL
  • publish_date — timestamp — NOT NULL
  • price — int8 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_card

  • card_id — int8 — Primary key — NOT NULL
  • payment_id — int8 — Foreign key → tb_payment.payment_id — NOT NULL
  • payment_price — int8
  • issuer — varchar(20)
  • acquirer — varchar(20)
  • card_number — varchar(20)
  • installment_plan_months — int4
  • approve_no — varchar(10)
  • use_card_point — varchar(1)
  • card_type — varchar(10)
  • owner_type — varchar(10)
  • acquire_status — varchar(20)
  • is_interest_free — varchar(1)
  • interest_payer — varchar(20)

tb_cart

  • cart_number — int8 — Primary key — NOT NULL
  • member_number — int8 — Foreign key → tb_member.member_id — NOT NULL
  • goods_number — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • store_number — int8 — Foreign key → tb_goods.store_id — NOT NULL
  • category_code — varchar(9) — Foreign key → tb_goods.category_code — NOT NULL — 001001001
  • item_number — int8
  • order_quantity — int4

tb_children

  • children_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • nick_name — varchar(20) — NOT NULL
  • birthday — varchar(8) — NOT NULL
  • gender — varchar(20) — NOT NULL
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255) — ENFP 등 16개
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)

tb_children_interest

  • children_id — int8 — Foreign key → tb_children.children_id — NOT NULL
  • member_id — int8 — Foreign key → tb_children.member_id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

tb_coupon

  • user_id (coupon_id) — int8 — Primary key — NOT NULL
  • coupon_name — varchar(100) — NOT NULL
  • coupon_kind_code — bpchar(20) — NOT NULL — 상품쿠폰/회원가입쿠폰/코드발급쿠폰
  • coupon_type_code — varchar(20) — NOT NULL — 정액/정률
  • apply_start_date — timestamp
  • apply_end_date — timestamp
  • apply_term — in4
  • apply_target_code — bpchar(20) — NOT NULL — 모든 상품/특정 상품/특정 카테고리
  • discount_price — int8 — 1000
  • discount_rate — int4 — 10
  • min_apply_price — int8 — 정액 적용 시(10,000원 구매 이상)
  • max_discount_price — int8 — 정률 적용 시(5,000원 할인)
  • quantity_limit_yn — bpchar(1) — NOT NULL
  • quantity_limit_count — int4 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL
  • issue_coupon_code — varchar(20) — 코드발급쿠폰 선택시
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

tb_coupon_category

  • coupon_category_id — int8 — Primary key — NOT NULL
  • coupon_number — int8 — Foreign key → tb_coupon.user_id — NOT NULL
  • category_code — varchar(9) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_coupon_goods

  • coupon_goods_id — int8 — Primary key — NOT NULL
  • coupon_id — int8 — Foreign key → tb_coupon.user_id — NOT NULL
  • goods_id — int8 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_coupon_issue

  • coupon_issue_id — int8 — Primary key — NOT NULL
  • coupon_id — int8 — Foreign key → tb_coupon.user_id — NOT NULL
  • coupon_issue_name — varchar(100) — NOT NULL
  • issue_date — date — NOT NULL
  • issue_time — time — NOT NULL
  • reservation_issue_yn — bpchar(1) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_easypay

  • easypay_id — int8 — Primary key — NOT NULL
  • payment_id — int8 — Foreign key → tb_payment.payment_id — NOT NULL
  • provider — varchar(20)
  • payment_price — int8
  • discount_price — int8

tb_goods

  • goods_id — int8 — Primary key — NOT NULL
  • category_code — varchar(9) — Foreign key → tb_goods_category.category_code — NOT NULL — 001001001
  • store_id — int8 — Foreign key → store.store_id — NOT NULL
  • goods_name — varchar(100) — NOT NULL
  • goods_type_code — bpchar(20) — NOT NULL — 체험/체험연계책/책
  • approval_status_code — varchar(20) — NOT NULL — 승인/대기/거절
  • sale_status_code — bpchar(20) — NOT NULL — 판매대기/판매중/품절
  • sale_start_date — timestamp — NOT NULL — 2023-01-01
  • sale_end_date — timestamp — NOT NULL — 9999-12-31
  • display_yn — bpchar(1) — NOT NULL
  • thumbnail_path — varchar(300) — NOT NULL
  • hcode — varchar(10)
  • bcode — bpchar(10) — 1156011000
  • region_depth_name1 — varchar(20) — 서울특별시
  • region_depth_name2 — varchar(20) — 영등포구
  • region_depth_name3 — varchar(20) — 여의도동
  • post_number — varchar(6)
  • road_address — varchar(100) — 서울특별시 영등포구 여의도동
  • road_address_detail — varchar(100)
  • place_name — varchar(100)
  • place_help — text
  • goods_summary — text
  • goods_description — text
  • use_information — text
  • refund_information — text
  • view_count — int4 — NOT NULL
  • refund_possible_yn — bpchar(1) — NOT NULL
  • review_count — int4 — NOT NULL
  • star_count — int4 — NOT NULL
  • star_sum — int4 — NOT NULL
  • star_average — numeric(2, 2) — NOT NULL
  • favorite_goods_setting_count — int4 — NOT NULL
  • cart_setting_count — int4 — NOT NULL
  • accumulate_sale_price — int8 — NOT NULL
  • accumulate_sale_quantity — int4 — NOT NULL
  • max_join_quantity — int4
  • recommendation_start_age — int4
  • recommendation_end_age — int4
  • guardian_join_yn — varchar(1)
  • reservation_possible_term — int4
  • cancel_possible_term — int4
  • lead_time — int4
  • relation_information_yn — bpchar(1) — NOT NULL
  • books_id — int8
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_badge

  • goods_badge_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • goods_badge_preset_id — int8 — Foreign key → tb_goods_badge_preset.goods_badge_preset_id — NOT NULL
  • goods_badge_name — varchar(100) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_badge_preset

  • goods_badge_preset_id — int8 — Primary key — NOT NULL
  • goods_badge_name — varchar(100) — NOT NULL
  • sort — int4
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_category

  • category_code — varchar(9) — Primary key — NOT NULL — 카테고리 코드
  • category_name — varchar(20) — NOT NULL — 카테고리 명
  • up_category_code — varchar(9) — NOT NULL — 상위 카테고리 코드
  • category_level — bpchar(1) — NOT NULL — 카테고리 레벨
  • sort — inr4 — NOT NULL — 정렬
  • use_yn — bpchar(1) — NOT NULL — 사용 여부
  • delete_yn — bpchar(1) — NOT NULL — 삭제 여부

tb_goods_favorite

  • goods_favorite_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL

tb_goods_image

  • goods_image_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • image_type_code — bpchar(20) — NOT NULL — 상세/상품정보
  • image_path — varchar(300) — NOT NULL
  • sort — int4 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_question

  • goods_question_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • question — varchar(300) — NOT NULL
  • mandatory_yn — bpchar(1) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_review

  • goods_review_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • order_id — int8 — Foreign key → tb_order_detail.order_id — NOT NULL
  • order_detail_id — int8 — Foreign key → tb_order_detail.order_detail_id — NOT NULL
  • goods_id — int8 — Foreign key → tb_item.goods_id — NOT NULL
  • store_id — int8 — Foreign key → tb_item.store_id — NOT NULL
  • item_id — int8 — Foreign key → tb_item.item_id — NOT NULL
  • review_content — text
  • star — int4
  • like_count — int4

tb_goods_review_image

  • review_image_number — int8 — Primary key — NOT NULL
  • review_number — int8 — Foreign key → tb_goods_review.goods_review_id — NOT NULL
  • goods_number — int8 — Foreign key → tb_goods_review.goods_id — NOT NULL
  • store_number — int8 — Foreign key → tb_goods_review.store_id — NOT NULL
  • order_number — int8 — Foreign key → tb_goods_review.order_id — NOT NULL
  • image_path — varchar(300)
  • delete_yn — bpchar(1)

tb_goods_tag

  • goods_tag_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • goods_tag_preset_id — int8 — Foreign key → tb_goods_tag_preset.goods_tag_preset_id — NOT NULL
  • goods_tag_name — varchar(100) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_goods_tag_preset

  • goods_tag_preset_id — int8 — Primary key — NOT NULL
  • goods_tag_name — varchar(100) — NOT NULL
  • sort — int4
  • delete_yn — bpchar(1) — NOT NULL

tb_instructor

  • instructor_id — int — Primary key — NOT NULL
  • store_id — int8 — Foreign key → store.store_id — NOT NULL
  • nick_name — varchar(100)
  • instructor_name — varchar(100)
  • instructor_introduction — text

tb_item

  • item_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_goods.goods_id — NOT NULL
  • store_id — int8 — Foreign key → tb_goods.store_id — NOT NULL
  • item_name — varchar(100) — NOT NULL
  • item_type_code — varchar(20) — NOT NULL — 옵션형/단독형
  • purchase_price — int8 — NOT NULL
  • customer_price — int8 — NOT NULL
  • sale_price — int8 — NOT NULL
  • stock_quantity — int4 — NOT NULL
  • sale_quantity — int4 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_item_amt_chg_his

  • seq_no — int8 — Primary key — NOT NULL
  • item_no — int8 — Foreign key → tb_item.item_id — NOT NULL
  • gds_no — int8 — Foreign key → tb_item.goods_id — NOT NULL
  • chg_dt — timestamp
  • chg_cd — bpchar(20) — 증가/감소
  • chg_amt — numeric(20, 2)

tb_item_option

  • item_option_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_item.goods_id — NOT NULL
  • item_id — int8 — Foreign key → tb_item.item_id — NOT NULL
  • store_id — int8 — Foreign key → tb_item.store_id — NOT NULL
  • item_option_name — varchar(100) — NOT NULL
  • purchase_price — int8 — NOT NULL
  • customer_price — int8 — NOT NULL
  • sale_price — int8 — NOT NULL
  • sale_quantity — int4 — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_item_qty_chg_his

  • seq_no — int8 — Primary key — NOT NULL
  • item_no — int8 — Foreign key → tb_item.item_id — NOT NULL
  • gds_no — int8 — Foreign key → tb_item.goods_id — NOT NULL
  • chg_dt — timestamp
  • chg_cd — bpchar(20) — 증가/감소
  • chg_amt — numeric(20, 2)

tb_item_schedule

  • item_schedule_id — int8 — Primary key — NOT NULL
  • goods_id — int8 — Foreign key → tb_item.goods_id — NOT NULL
  • item_id — int8 — Foreign key → tb_item.item_id — NOT NULL
  • store_id — int8 — Foreign key → tb_item.store_id — NOT NULL
  • instructor_id — int8
  • reservation_possible_date — date — NOT NULL
  • day — varchar(20) — NOT NULL
  • reservation_possible_start_time — time — NOT NULL
  • reservation_possible_end_time — time — NOT NULL
  • reservation_possible_number — int4 — NOT NULL
  • reservation_meet_number — int4 — NOT NULL
  • sale_quantity — int4 — NOT NULL
  • reservation_possible_yn — bpchar(1) — NOT NULL
  • delete_yn — bpchar(1) — NOT NULL

tb_member

  • member_id — int8 — Primary key — NOT NULL
  • id — varchar(20)
  • sns_id — varchar(100)
  • member_status_code — bpchar(20) — NOT NULL — 정상/휴면/탈퇴
  • nick_name — varchar(20) — NOT NULL
  • member_name — varchar(20) — NOT NULL
  • profile_image_path — varchar(300)
  • password — varchar(100)
  • password_change_date — timestamp
  • password_change_advice_date — timestamp
  • password_error_count — int4 — NOT NULL
  • mobile_number — varchar(20) — NOT NULL
  • email — varchar(100)
  • birthday — varchar(8)
  • gender — bpchar(20)
  • hcode — varchar(10)
  • bcode — varchar(10)
  • region_depth_name1 — varchar(20)
  • region_depth_name2 — varchar(20)
  • region_depth_name3 — varchar(20)
  • post_number — varchar(6)
  • road_address — varchar(100)
  • road_address_detail — varchar(100)
  • real_name_certification_yn — bpchar(1) — NOT NULL
  • ci — varchar(100)
  • ci_change_date — timestamp
  • di — varchar(100)
  • di_change_date — timestamp
  • join_path — bpchar(20) — NOT NULL
  • join_date — timestamp — NOT NULL
  • dormant_date — timestamp
  • withdrawal_date — timestamp
  • dormant_transition_term — int4 — NOT NULL
  • marketing_email_receive_yn — bpchar(1) — NOT NULL
  • marketing_email_receive_change_date — timestamp
  • marketing_mobile_receive_yn — bpchar(1) — NOT NULL
  • marketing_mobile_receive_change_date — timestamp
  • night_mobile_receive_yn — bpchar(1) — NOT NULL
  • night_mobile_receive_change_date — timestamp
  • recent_access_date — timestamp
  • recommend_id — varchar(20)

tb_member_auth

  • member_auth_id — int8 — Primary key — NOT NULL
  • auth_type — varchar(10) — NOT NULL — 이메일/핸드폰
  • auth_target — varchar(100) — NOT NULL — 이메일주소/핸드폰번호
  • auth_number — varchar(10) — NOT NULL
  • auth_yn — varchar(1)
  • expire_date — timestamp — NOT NULL — 휴대폰 3분, 이메일 10분
  • registry_date — timestamp — NOT NULL
  • check_count — int4 — NOT NULL

tb_member_coupon

  • member_coupon_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • coupon_id — int8 — Foreign key → tb_coupon.user_id — NOT NULL
  • apply_start_date — timestamp — NOT NULL
  • apply_end_date — timestamp — NOT NULL
  • use_date — timestamp
  • issue_yn — bpchar(1) — NOT NULL
  • expire_yn — bpchar(1)

tb_member_coupon_use

  • member_coupon_use_id — int8 — Primary key — NOT NULL
  • member_coupon_id — int8 — Foreign key → tb_member_coupon.member_coupon_id — NOT NULL
  • coupon_id — int8 — Foreign key → tb_member_coupon.coupon_id — NOT NULL
  • order_id — int8 — Foreign key → tb_order.order_id — NOT NULL
  • order_detail_id — int8 — NOT NULL
  • coupon_type_code — bpchar(20) — NOT NULL — 정액/정률
  • coupon_use_price — int8 — NOT NULL
  • coupon_refund_yn — bpchar(1) — NOT NULL — 취소로 인한 쿠폰 환급 여부

tb_member_delivery_address

  • member_delivery_address_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • receiver_name — varchar(20) — NOT NULL
  • mobile_number — varchar(20) — NOT NULL
  • hcode — varchar(10) — NOT NULL
  • bcode — varchar(10) — NOT NULL
  • region_depth_name1 — varchar(20)
  • region_depth_name2 — varchar(20)
  • region_depth_name3 — varchar(20)
  • post_number — varchar(6) — NOT NULL
  • road_address — varchar(100)
  • road_address_detail — varchar(100)
  • delivery_name — varchar(20) — 집/회사
  • default_yn — bpchar(1) — NOT NULL

tb_member_dormant

  • Key — VARCHAR(255) — Primary key — NOT NULL

tb_member_svmn

  • svmn_no — int8 — Primary key — NOT NULL
  • mem_no — int8 — Foreign key → tb_member.member_id — NOT NULL
  • ord_no — int8 — Foreign key → tb_order.order_id — NOT NULL
  • svmn_type_cd — bpchar(20) — 구매
  • start_dt — timestamp — 2023-06-01
  • end_dt — timestamp — 2023-06-30
  • use_psb_amt — numeric(20, 2)
  • use_psb_yn — bpchar(1)

tb_member_svmn_use

  • svmn_use_no — int8 — Primary key — NOT NULL
  • svmn_no — int8 — Foreign key → tb_member_svmn.svmn_no — NOT NULL
  • mem_no — int8 — Foreign key → tb_member_svmn.mem_no — NOT NULL
  • ord_no — int8 — Foreign key → tb_member_svmn.ord_no — NOT NULL
  • sbt_type_cd — bpchar(20) — 차감/복원
  • prcs_amt — numeric(20, 2)

tb_member_token

  • member_token_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • device_type — varchar(10) — NOT NULL — iOS/AOS/PC
  • device_uuid — varchar(64) — NOT NULL — UUID
  • refresh_token — varchar(300) — 로그아웃 시 NULL
  • token_use_date — timestamp — NOT NULL

tb_member_withdrawal

  • withdrawal_member_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • withdrawal_reason — varchar(200)
  • withdrawal_date — timestamp — NOT NULL

tb_order

  • order_id — int8 — Primary key — NOT NULL
  • order_number — varchar(64) — NOT NULL — 2023010100001
  • member_id — int8
  • order_status_code — bpchar(20) — NOT NULL — 접수/완료/취소/환불
  • sale_channel_code — bpchar(20) — NOT NULL — AOS, IOS, PC
  • member_name — varchar(20)
  • email — varchar(100)
  • mobile_number — varchar(20)
  • order_accept_date — timestamp
  • order_complete_date — timestamp
  • order_cancel_date — timestamp
  • payment_complete_date — timestamp
  • sale_price — int8 — NOT NULL
  • discount_price — int8 — NOT NULL
  • payment_price — int8 — NOT NULL
  • reward_price — int8 — NOT NULL
  • order_quantity — int4 — NOT NULL
  • original_order_id — int8 — 주문 환불 시
  • accumulate_cancel_quantity — int4 — NOT NULL
  • accumulate_cancel_payment_price — int8 — NOT NULL
  • accumulate_cancel_sequence — int4 — NOT NULL
  • order_memo — varchar(300)

tb_order_account

  • Key — VARCHAR(255) — Foreign key → tb_order_detail.order_detail_id — NOT NULL
  • ord_no — int8 — Foreign key → tb_order_detail.order_id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)
  • Field7 — VARCHAR(255)
  • Field8 — VARCHAR(255) — 수수료정산/매입정산
  • Field9 — VARCHAR(255) — 주/월
  • Field10 — VARCHAR(255) — 주문일자/구매확정일자
  • Field12 — VARCHAR(255)
  • Field13 — VARCHAR(255)
  • Field14 — VARCHAR(255)
  • Field15 — VARCHAR(255)
  • Field16 — VARCHAR(255)
  • Field17 — VARCHAR(255)
  • Field18 — VARCHAR(255)
  • Field19 — VARCHAR(255)
  • Field20 — VARCHAR(255)
  • Field21 — VARCHAR(255)
  • Field22 — VARCHAR(255)
  • Field23 — VARCHAR(255)
  • Field24 — VARCHAR(255)
  • Field25 — VARCHAR(255)
  • Field26 — VARCHAR(255)
  • Field27 — VARCHAR(255)
  • Field28 — VARCHAR(255)
  • Field29 — VARCHAR(255)
  • Field30 — VARCHAR(255)
  • Field31 — VARCHAR(255)
  • Field32 — VARCHAR(255)
  • Field11 — VARCHAR(255)
  • Field33 — VARCHAR(255)
  • Field34 — VARCHAR(255)

tb_order_claim

  • claim_id — int8 — Primary key — NOT NULL
  • order_id — int8 — Foreign key → tb_order_detail.order_id — NOT NULL
  • order_detail_id — int8 — Foreign key → tb_order_detail.order_detail_id — NOT NULL
  • claim_type_code — bpchar(20) — NOT NULL — 취소/환불
  • claim_status_code — bpchar(20)
  • claim_accept_date — timestamp
  • claim_complete_date — timestamp
  • claim_quantiy — int4 — NOT NULL
  • claim_price — numeric(20, 2) — NOT NULL
  • claim_reason — varchar(200)

tb_order_delivery_address

  • order_delivery_id — int8 — Primary key — NOT NULL
  • order_id — int8 — Foreign key → tb_order.order_id — NOT NULL
  • member_id — int8 — Foreign key → tb_member.member_id — NOT NULL
  • delivery_name — varchar(20) — 집/회사
  • receiver_name — varchar(20) — NOT NULL
  • mobile_number — varchar(20) — NOT NULL
  • post_number — varchar(6) — NOT NULL
  • road_address — varchar(100) — NOT NULL
  • road_address_detail — varchar(100) — NOT NULL
  • delivery_message — varchar(300)

tb_order_detail

  • order_detail_id — int8 — Primary key — NOT NULL
  • order_id — int8 — Foreign key → tb_order.order_id — NOT NULL
  • goods_id — int8 — NOT NULL
  • item_id — int8 — NOT NULL
  • option_id — int8 — NOT NULL
  • item_schedule_id — int8
  • store_id — int8 — NOT NULL
  • category_code — varchar(9) — NOT NULL
  • order_detail_status_code — varchar(20) — NOT NULL — 접수/완료/취소/환불
  • goods_name — varchar(100) — NOT NULL
  • item_name — varchar(100) — NOT NULL
  • option_name — varchar(100)
  • buy_confirm_date — timestamp
  • purchase_price — int8 — NOT NULL
  • sale_price — int8 — NOT NULL
  • discount_price — int8 — NOT NULL
  • payment_price — int8 — NOT NULL
  • reward_price — int8 — NOT NULL
  • order_quantity — int4 — NOT NULL
  • accumulate_cancel_quantity — int4 — NOT NULL
  • accumulate_cancel_payment_price — int8 — NOT NULL
  • accumulate_cancel_sequence — int4 — NOT NULL

tb_order_goods_question

  • order_goods_question_id — int8 — Primary key — NOT NULL
  • order_id — int8 — Foreign key → tb_order.order_id — NOT NULL
  • goods_question_id — int8 — Foreign key → tb_goods_question.goods_question_id — NOT NULL
  • question — varchar(300) — NOT NULL
  • reply — varchar(300) — NOT NULL

tb_order_part

  • ord_ptct_no — int8 — Primary key — NOT NULL
  • ord_no — int8 — Foreign key → tb_order.order_id — NOT NULL
  • ptct_type_cd — bpchar(20) — 부모/자녀
  • ref_no — int8 — 회원 번호, 자녀 번호

tb_partner_account

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • ptn_no — int8 — Foreign key → store.store_id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255) — 수수료정산/매입정산
  • Field4 — VARCHAR(255) — 주/월
  • Field5 — VARCHAR(255) — 주문일자/구매확정일자
  • Field6 — VARCHAR(255)

tb_payment

  • payment_id — int8 — Primary key — NOT NULL
  • order_id — int8 — Foreign key → tb_order.order_id — NOT NULL
  • pg_company_code — varchar(20) — NOT NULL
  • mid — varchar(20) — NOT NULL
  • method_code — varchar(20) — NOT NULL
  • status_code — varchar(20) — NOT NULL
  • request_date — timestamp — NOT NULL
  • response_date — timestamp
  • currency — varchar(10)
  • supply_price — int8 — NOT NULL
  • vat — int8 — NOT NULL
  • tax_free_price — int8 — NOT NULL
  • payment_price — int8 — NOT NULL
  • order_number — varchar(20) — NOT NULL
  • orderName — varchar(100) — NOT NULL
  • payment_key — varchar(200)
  • result_code — varchar(20)
  • result_message — text