팀 3

테이블 (19)

UserPolicySetting (user_policy_setting)

  • userPolicySettingId (user_policy_setting_id) — bigint(20) — 기본 키 — NOT NULL
  • amazon_auto_pricing_enabled — bit(1) — NOT NULL
  • base_shipping_fee — decimal(38,2) — NOT NULL
  • card_fee_rate — decimal(38,2) — NOT NULL
  • competitorAutoPricingEnabled (competitor_auto_pricing_enabled) — bit(1) — NOT NULL
  • exchangeRate (exchange_rate) — decimal(38,2) — NOT NULL
  • marketCode (market_code) — enum('AUCTION','COUPANG','ELEVEN_STREET','GMARKET','NAVER_SMART_STORE') — NOT NULL
  • marketFeeRate (market_fee_rate) — decimal(38,2) — NOT NULL
  • minMarginAmount (min_margin_amount) — decimal(38,2) — NOT NULL
  • minMarginProtectEnabled (min_margin_protect_enabled) — bit(1) — NOT NULL
  • priceAutoUpdateEnabled (price_auto_update_enabled) — bit(1) — NOT NULL
  • remoteAreaExtraShippingFee (remote_area_extra_shipping_fee) — decimal(38,2) — NOT NULL
  • return_shipping_fee — decimal(38,2) — NOT NULL
  • price_rounding_unit — enum('FIFTY_WON','HUNDRED_WON','TEN_THOUSAND_WON','TEN_WON','THOUSAND_WON') — NOT NULL
  • shipping_fee_type — enum('FREE_SHIPPING','PAID_SHIPPING') — NOT NULL
  • stop_loss_enabled — bit(1) — NOT NULL
  • targetMarginRate (target_margin_rate) — decimal(38,2) — NOT NULL
  • userId (user_id) — bigint(20) — 외래 키 → users.user_id — NOT NULL
  • auto_publish_enabled — bit(1) — NOT NULL

card

  • card_id (id) — bigint(20) — 기본 키 — NOT NULL
  • active — bit(1) — NOT NULL
  • balance — bigint(20) — NOT NULL
  • card_limit — bigint(20)
  • card_number — varchar(255)
  • card_type — varchar(255)
  • cvc_encrypted — varchar(255)
  • expiry_encrypted — varchar(255)

dummy_coupang_product

  • dummy_coupang_product_id — bigint(20) — 기본 키 — NOT NULL
  • dummy_product_registration_id (dummy_product_registration_id2) — bigint(20) — 외래 키 → dummy_product_registration.dummy_product_registration_id — NOT NULL
  • brand — varchar(255) — NOT NULL
  • currency — varchar(10) — NOT NULL
  • main_image_url — varchar(1000)
  • original_price — decimal(38,2) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • sale_price — decimal(38,2) — NOT NULL
  • shipping_fee — decimal(38,2) — NOT NULL
  • source_product_id — varchar(255) — NOT NULL
  • source_url — varchar(1000) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • margin_krw — decimal(38,2) — NOT NULL
  • user_id (id) — bigint(20) — 외래 키 → users.user_id — NOT NULL

dummy_coupang_product_image

  • dummy_coupang_product_image_id — bigint(20) — 기본 키 — NOT NULL
  • image_type — enum('DESCRIPTION','MAIN','OPTION') — NOT NULL
  • image_url — varchar(1000) — NOT NULL
  • option_asin — varchar(255)
  • sort_order — int(11)
  • dummy_coupang_product_id (dummy_coupang_product_id2) — bigint(20) — 외래 키 → dummy_coupang_product.dummy_coupang_product_id — NOT NULL
  • bucket_name — varchar(100)
  • object_key — varchar(1000)
  • dummy_product_registration_id (dummy_product_registration_id2) — bigint(20) — 외래 키 → dummy_coupang_product.dummy_product_registration_id — NOT NULL

dummy_coupang_product_option

  • dummy_coupang_product_option_id — bigint(20) — 기본 키 — NOT NULL
  • dummy_coupang_product_id (dummy_coupang_product_id2) — bigint(20) — 외래 키 → dummy_coupang_product.dummy_coupang_product_id — NOT NULL
  • dummy_product_registration_id (dummy_product_registration_id2) — bigint(20) — 외래 키 → dummy_coupang_product.dummy_product_registration_id — NOT NULL
  • currency — varchar(10)
  • option_asin — varchar(255) — NOT NULL
  • option_dimensions — tinytext
  • price — decimal(38,2)
  • selected — bit(1) — NOT NULL
  • stock — varchar(1000)

dummy_product_image

  • dummy_product_image_id — bigint(20) — 기본 키 — NOT NULL
  • dummy_product_registration_id (dummy_product_registration_id2) — bigint(20) — 외래 키 → dummy_product_registration.dummy_product_registration_id — NOT NULL
  • image_type — enum('DESCRIPTION','MAIN','OPTION') — NOT NULL
  • image_url — varchar(1000) — NOT NULL
  • option_asin — varchar(255)
  • sort_order — int(11)
  • bucket_name — varchar(100)
  • object_key — varchar(1000)

dummy_product_option

  • DummyProductOptionId (dummy_product_option_id) — bigint(20) — 기본 키 — NOT NULL
  • dummyProductRegistrationId (dummy_product_registration_id2) — bigint(20) — 외래 키 → dummy_product_registration.dummy_product_registration_id — NOT NULL
  • currency — varchar(10)
  • optionAsin (option_asin) — varchar(255) — NOT NULL
  • option_dimensions — tinytext
  • price — decimal(38,2)
  • rating — double
  • reviews_count — int(11)
  • selected — bit(1) — NOT NULL
  • stock — varchar(1000)
  • salePrice (sale_price) — decimal(38,2)

dummy_product_registration

  • dummy_product_registration_id — bigint(20) — 기본 키 — NOT NULL
  • cost_in_krw — decimal(38,2) — NOT NULL
  • currency — varchar(255) — NOT NULL
  • exchange_rate — decimal(38,2) — NOT NULL
  • exclusion_reason — varchar(255)
  • market_code — enum('AUCTION','COUPANG','ELEVEN_STREET','GMARKET','NAVER_SMART_STORE') — NOT NULL
  • original_price — decimal(38,2) — NOT NULL
  • processed_brand — varchar(255) — NOT NULL
  • processed_product_name — varchar(255) — NOT NULL
  • registration_status — enum('READY','REGISTERED','BLOCKED','FAILED','CANCELED') — NOT NULL
  • sale_price — decimal(38,2) — NOT NULL
  • shipping_fee — decimal(38,2) — NOT NULL
  • source_product_id — varchar(255) — NOT NULL
  • source_url — varchar(255) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • main_image_url — varchar(255)
  • margin_krw — decimal(38,2) — NOT NULL
  • received_at — datetime(6) — NOT NULL
  • registered_at — datetime(6)

orders

  • order_id (id) — bigint(20) — 기본 키 — NOT NULL
  • auto_order_status — varchar(255)
  • customer_name — varchar(255)
  • customer_phone — varchar(255)
  • margin — int(11) — NOT NULL
  • overseas_mall — varchar(255)
  • status — varchar(255)
  • total_amount — int(11) — NOT NULL
  • user_id — bigint(20)

payment

  • id — bigint(20) — 기본 키 — NOT NULL
  • amount — int(11) — NOT NULL
  • status — varchar(255)
  • card_id (id2) — bigint(20) — 외래 키 → card.card_id — NOT NULL
  • order_id (id3) — bigint(20) — 외래 키 → orders.order_id — NOT NULL

shipment

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id (id2) — bigint(20) — 외래 키 → orders.order_id — NOT NULL
  • courier — varchar(50) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • status — enum('DELIVERED','READY','SHIPPING') — NOT NULL
  • tracking_number — varchar(100) — NOT NULL
  • updated_at — datetime(6)

sourcing

  • id — bigint(20) — 기본 키 — NOT NULL
  • brand — varchar(255)
  • currency — varchar(255)
  • krw_price — decimal(38,2)
  • main_image_url — varchar(255)
  • original_price — decimal(38,2)
  • product_id — varchar(255)
  • registration_status — enum('NORMALIZATION_FAILED','NORMALIZED','PENDING_NORMALIZATION','PRODUCT_DELETED','PRODUCT_REGISTERED')
  • result_image_url — varchar(255)
  • site_name — varchar(255)
  • source_url — varchar(2048)
  • title — varchar(255)
  • translated_brand — varchar(255)
  • translated_title — varchar(255)
  • user_id — bigint(20) — NOT NULL
  • result_image_minio_key — varchar(1024)

sourcing_description_images

  • id — bigint(20) — 외래 키 → sourcing.id — NOT NULL
  • description_images — varchar(255)

sourcing_variation

  • id — bigint(20) — 외래 키 → sourcing.id — NOT NULL
  • asin — varchar(255)
  • currency — varchar(255)
  • price — decimal(38,2)
  • rating — double
  • reviews_count — int(11)
  • selected — bit(1) — NOT NULL
  • stock — varchar(2048)
  • sourcing_id — bigint(20)

sourcing_variation_dimensions

  • variation_id — bigint(20) — 기본 키 — NOT NULL
  • dimension_key — varchar(255) — 기본 키 — NOT NULL
  • dimension_value — varchar(255)

sourcing_variation_images

  • variation_id (variation_id2) — bigint(20) — 외래 키 → sourcing_variation_dimensions.variation_id — NOT NULL
  • dimension_key — varchar(255) — 외래 키 → sourcing_variation_dimensions.dimension_key — NOT NULL
  • image_url — varchar(2048)

user_blocked_word

  • user_blocked_word_id — bigint(20) — 기본 키 — NOT NULL
  • blocked_word — varchar(255) — NOT NULL
  • user_id — bigint(20) — 외래 키 → users.user_id — NOT NULL

user_replacement_word

  • user_replacement_id — bigint(20) — 기본 키 — NOT NULL
  • replacement_word — varchar(255) — NOT NULL
  • source_word — varchar(255) — NOT NULL
  • user_id — bigint(20) — 외래 키 → users.user_id — NOT NULL

users

  • user_id (id) — bigint(20) — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • locked — bit(1) — NOT NULL
  • login_fail_count — int(11) — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • username — varchar(255) — NOT NULL
  • phone_number — varchar(255)
  • profile_image — varchar(255)
  • provider — enum('GOOGLE','KAKAO','LOCAL','NAVER')
  • provider_id — varchar(255)
  • social_linked — bit(1)