팀 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)