종프_최종
테이블 (35)
address
- address_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- recipient — varchar(50) — NOT NULL
- phone — varchar(20) — NOT NULL
- zipcode — varchar(10) — NOT NULL
- road_address — varchar(255) — NOT NULL
- detail_address — varchar(255)
- is_default — tinyint(1) — NOT NULL
- is_default_key — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
admin
- admin_id — bigint — 기본 키 — NOT NULL
- login_id — varchar(50) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- role — varchar(30) — NOT NULL
- status — varchar(30) — NOT NULL
- refresh_token_hash — char(64)
- refresh_token_expires_at — datetime(6)
- deleted_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
audit_log
- audit_log_id — bigint — 기본 키 — NOT NULL
- admin_id — bigint — 외래 키 → admin.admin_id — NOT NULL
- action — varchar(50) — NOT NULL
- target — varchar(100)
- detail — text
- created_at — datetime(6) — NOT NULL
campaign_target_lot
- campaign_target_lot_id — bigint — 기본 키 — NOT NULL
- target_date — date — NOT NULL
- stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
- turnover_rate — decimal(5,4) — NOT NULL
- issuable_qty — int — NOT NULL
- target_rank — int — NOT NULL
- created_at — datetime(6) — NOT NULL
cart
- cart_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
cart_item
- cart_item_id — bigint — 기본 키 — NOT NULL
- cart_id — bigint — 외래 키 → cart.cart_id — NOT NULL
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- qty — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
category
- category_id — bigint — 기본 키 — NOT NULL
- parent_id — bigint — 외래 키 → category.category_id
- parent_key — bigint
- name — varchar(50) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
claim
- claim_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id — NOT NULL
- type — varchar(30) — NOT NULL
- status — varchar(30) — NOT NULL
- reason_type — varchar(30)
- reason — varchar(500)
- processed_by — bigint — 외래 키 → admin.admin_id
- processed_at — datetime(6)
- collect_carrier — varchar(50)
- collect_tracking_no — varchar(50)
- collect_shipped_at — datetime(6)
- collect_delivered_at — datetime(6)
- reship_carrier — varchar(50)
- reship_tracking_no — varchar(50)
- reship_shipped_at — datetime(6)
- reship_delivered_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
claim_attachment
- claim_attachment_id — bigint — 기본 키 — NOT NULL
- claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
- upload_id — binary(16) — NOT NULL
- object_key — varchar(255) — NOT NULL
- upload_status — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
claim_item
- claim_item_id — bigint — 기본 키 — NOT NULL
- claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
- order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
- order_id — bigint — 외래 키 → order_item.order_id — NOT NULL
- created_at — datetime(6) — NOT NULL
coupon
- coupon_id — bigint — 기본 키 — NOT NULL
- name — varchar(100) — NOT NULL
- scope — varchar(20) — NOT NULL
- discount_type — varchar(30) — NOT NULL
- discount_value — int — NOT NULL
- max_discount_amount — int
- min_order_amount — int — NOT NULL
- total_quantity — int
- issued_quantity — int — NOT NULL
- issue_start_at — datetime(6)
- issue_end_at — datetime(6)
- valid_from — date — NOT NULL
- valid_to — date — NOT NULL
- target_grade_id — bigint — 외래 키 → member_grade.member_grade_id
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
coupon_product_option
- coupon_product_option_id — bigint — 기본 키 — NOT NULL
- coupon_id — bigint — 외래 키 → coupon.coupon_id — NOT NULL
- scope — varchar(20) — 외래 키 → coupon.scope — NOT NULL
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
daily_sales
- daily_sales_id — bigint — 기본 키 — NOT NULL
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- stat_date — date — NOT NULL
- opening_stock — int — NOT NULL
- inbound_qty — int — NOT NULL
- restocked_qty — int — NOT NULL
- sold_qty — int — NOT NULL
- sold_amount — bigint — NOT NULL
- disposed_qty — int — NOT NULL
- expired_qty — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
kakao_unlink_failure
- kakao_unlink_failure_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- kakao_user_id — varchar(100) — NOT NULL
- attempt_count — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- resolved — tinyint(1) — NOT NULL
member
- member_id — bigint — 기본 키 — NOT NULL
- provider — varchar(30) — NOT NULL
- provider_user_id — varchar(100) — NOT NULL
- email — varchar(255)
- nickname — varchar(50)
- name — varchar(50)
- phone — varchar(20)
- member_grade_id — bigint — 외래 키 → member_grade.member_grade_id — NOT NULL
- is_marketing_agreed — tinyint(1) — NOT NULL
- status — varchar(30) — NOT NULL
- refresh_token_hash — char(64)
- refresh_token_expires_at — datetime(6)
- deleted_at — datetime(6)
- active_provider_key — varchar(140)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member_coupon
- member_coupon_id — bigint — 기본 키 — NOT NULL
- coupon_id — bigint — 외래 키 → coupon.coupon_id — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- scope — varchar(20) — 외래 키 → coupon.scope — NOT NULL
- issue_limit — int
- issue_seq — int
- status — varchar(30) — NOT NULL
- issued_at — datetime(6) — NOT NULL
- used_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member_coupon_status_history
- member_coupon_status_history_id — bigint — 기본 키 — NOT NULL
- member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id — NOT NULL
- from_status — varchar(30)
- to_status — varchar(30) — NOT NULL
- reason — varchar(255)
- changed_by — bigint — 외래 키 → admin.admin_id
- created_at — datetime(6) — NOT NULL
member_grade
- member_grade_id — bigint — 기본 키 — NOT NULL
- name — varchar(50) — NOT NULL
- promotion_rule — varchar(255)
- is_default — tinyint(1) — NOT NULL
- is_default_key — tinyint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
option_availability_sync_failure
- option_availability_sync_failure_id — bigint — 기본 키 — NOT NULL
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- sold_out — tinyint(1) — NOT NULL
- occurred_at — datetime(6) — NOT NULL
- attempt_count — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
order_item
- order_item_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id — NOT NULL
- source_cart_item_id — bigint
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- name_snapshot — varchar(255) — NOT NULL
- option_name_snapshot — varchar(100) — NOT NULL
- unit_price — int — NOT NULL
- qty — int — NOT NULL
- member_id — bigint — 외래 키 → orders.member_id — NOT NULL
- member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id
- coupon_id — bigint — 외래 키 → coupon_product_option.coupon_id
- coupon_discount — int — NOT NULL
- discount_amount — int — NOT NULL
- item_status — varchar(30) — NOT NULL
- active_coupon_key — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
order_status_history
- order_status_history_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id — NOT NULL
- from_status — varchar(30)
- to_status — varchar(30) — NOT NULL
- created_at — datetime(6) — NOT NULL
orders
- order_id — bigint — 기본 키 — NOT NULL
- order_no — varchar(30) — NOT NULL
- request_id — varchar(64)
- request_hash — char(64)
- member_id — bigint — 외래 키 → member_coupon.member_id — NOT NULL
- status — varchar(30) — NOT NULL
- product_amount — int — NOT NULL
- discount_amount — int — NOT NULL
- member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id
- coupon_scope — varchar(20) — 외래 키 → member_coupon.scope
- coupon_discount — int — NOT NULL
- active_coupon_key — bigint
- shipping_fee — int — NOT NULL
- total_amount — int — NOT NULL
- ship_recipient — varchar(50) — NOT NULL
- ship_phone — varchar(20) — NOT NULL
- ship_zipcode — varchar(10) — NOT NULL
- ship_address — varchar(500) — NOT NULL
- ship_message — varchar(255)
- ordered_at — datetime(6) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
payment
- payment_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id — NOT NULL
- method — varchar(30) — NOT NULL
- amount — int — 외래 키 → orders.total_amount — NOT NULL
- status — varchar(30) — NOT NULL
- refunded_amount — int — NOT NULL
- pg_tid — varchar(100)
- paid_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
product
- product_id — bigint — 기본 키 — NOT NULL
- product_code — varchar(50) — NOT NULL
- request_id — varchar(100) — NOT NULL
- name — varchar(255) — NOT NULL
- category_id — bigint — 외래 키 → category.category_id — NOT NULL
- supplier_id — bigint — 외래 키 → supplier.supplier_id — NOT NULL
- sale_status — varchar(30) — NOT NULL
- storage_type — varchar(30) — NOT NULL
- sale_available_days_from_expiry — int — NOT NULL
- description — text
- deleted_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
product_image
- product_image_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- request_id — varchar(100) — NOT NULL
- upload_id — binary(16) — NOT NULL
- object_key — varchar(255) — NOT NULL
- upload_status — varchar(20) — NOT NULL
- sort_order — int — NOT NULL
- is_main — tinyint(1) — NOT NULL
- is_main_key — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
product_option
- product_option_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- name — varchar(100) — NOT NULL
- price — int — NOT NULL
- sale_status — varchar(30) — NOT NULL
- sold_out — tinyint(1) — NOT NULL
- sold_out_synced_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
qna
- qna_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- title — varchar(255) — NOT NULL
- question — text — NOT NULL
- answer — text
- answered_by — bigint — 외래 키 → admin.admin_id
- is_public — tinyint(1) — NOT NULL
- status — varchar(30) — NOT NULL
- deleted_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
refund
- refund_id — bigint — 기본 키 — NOT NULL
- claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
- order_id — bigint — 외래 키 → payment.order_id — NOT NULL
- amount — int — NOT NULL
- shipping_deduction — int — NOT NULL
- status — varchar(30) — NOT NULL
- refunded_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
review
- review_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product_option.product_id — NOT NULL
- product_option_id — bigint — 외래 키 → order_item.product_option_id — NOT NULL
- member_id — bigint — 외래 키 → order_item.member_id — NOT NULL
- order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
- rating — tinyint — NOT NULL
- title — varchar(255)
- content — text — NOT NULL
- is_public — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
shipment
- shipment_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id — NOT NULL
- carrier — varchar(50)
- tracking_no — varchar(50)
- status — varchar(30) — NOT NULL
- shipped_at — datetime(6)
- delivered_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
shipment_photo
- shipment_photo_id — bigint — 기본 키 — NOT NULL
- shipment_id — bigint — 외래 키 → shipment.shipment_id — NOT NULL
- upload_id — binary(16) — NOT NULL
- object_key — varchar(255) — NOT NULL
- upload_status — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
stock_allocation
- stock_allocation_id — bigint — 기본 키 — NOT NULL
- order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
- stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
- qty — int — NOT NULL
- status — varchar(30) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
stock_lot
- stock_lot_id — bigint — 기본 키 — NOT NULL
- product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
- request_id — varchar(100) — NOT NULL
- received_date — date — NOT NULL
- expiry_date — date — NOT NULL
- initial_qty — int — NOT NULL
- available_qty — int — NOT NULL
- status — varchar(30) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
stock_movement
- stock_movement_id — bigint — 기본 키 — NOT NULL
- stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
- request_id — varchar(100)
- movement_type — varchar(30) — NOT NULL
- quantity — int — NOT NULL
- qty_before — int — NOT NULL
- qty_after — int — NOT NULL
- order_id — bigint — 외래 키 → orders.order_id
- admin_id — bigint — 외래 키 → admin.admin_id
- disposal_reason — varchar(30)
- reason — varchar(200)
- created_at — datetime(6) — NOT NULL
supplier
- supplier_id — bigint — 기본 키 — NOT NULL
- name — varchar(100) — NOT NULL
- contact — varchar(100)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL