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