cigro.io

Tables (13)

account

  • id (pk) — int4 — Primary key — NOT NULL — primary key
  • name (Field2) — varchar
  • type (Field3) — varchar
  • channel_name (Field4) — varchar
  • commission_rate (Field5) — float8
  • active (Field6) — bool
  • user_identifier (Field7) — varchar
  • exclude_channels (Field8) — varchar
  • status (Field9) — varchar
  • created_time (Field10) — timestamptz
  • include_channels (Field11) — varchar
  • alimtalk_sent (Field12) — bool
  • fail_noti (Field13) — bool
  • matching_brand_id (Field14) — int4
  • company_id (fk) — int4 — Foreign key → company.id — foreign key

account_secret

  • id (Key) — int4 — Primary key — NOT NULL — primary key
  • app_id (Field) — varchar
  • app_secret (Field2) — varchar
  • access_token (Field3) — varchar
  • refresh_token (Field4) — varchar
  • developer_token (Field5) — varchar
  • root_manager (Field6) — varchar
  • mall_id (Field7) — varchar
  • domain (Field8) — varchar
  • unique_value (Field9) — varchar
  • created_time (Field10) — timestamptz
  • account_id (pk) — int4 — Foreign key → account.id — NOT NULL — foreign key

ad (Untitled6)

  • id (Key) — varchar — Foreign key → ad_group.id — NOT NULL — primary key
  • ad_group_id (Key2) — varchar — Foreign key → ad_group.ad_campaign_id — NOT NULL — primary key, foreign key
  • ad_campaign_id (Key22) — varchar — Foreign key → ad_group.ad_campaign_id — NOT NULL — foreign key
  • account_id (pk) — int4 — Foreign key → account.id — NOT NULL — foreign key
  • landing_page (Field) — _varchar
  • name (Field2) — varchar
  • type (Field3) — varchar
  • image_url (Field4) — varchar
  • channel_name (Field5) — varchar
  • created_time (Field6) — timestamptz
  • brand_id (Key3) — int4 — Foreign key → brand.id — NOT NULL — foreign key

ad_campaign (Untitled4)

  • id (Key) — varchar — Primary key — NOT NULL — primary key
  • ad_manager_id (Key2) — varchar — Foreign key → ad_manager.id — NOT NULL — primary key, foreign key
  • name (Field3) — varchar
  • matching_brand_id (Field4) — int4
  • objective (Field5) — varchar
  • created_time (Field6) — timestamptz
  • account_id (pk) — int4 — Foreign key → ad_manager.account_id — NOT NULL — foreign key

ad_group (Untitled5)

  • id (Key) — varchar — Foreign key → ad_campaign.id — NOT NULL — primary key
  • ad_campaign_id (Key2) — varchar — Foreign key → ad_campaign.ad_manager_id — NOT NULL — primary key, foreign key
  • ad_manager_id (Key22) — varchar — Foreign key → ad_campaign.ad_manager_id — NOT NULL — foreign key
  • name (Field) — varchar
  • matching_brand_id (Field2) — int4
  • created_time (Field3) — timestamptz

ad_manager

  • id (Key) — varchar — Primary key — NOT NULL — primary key
  • account_id (pk) — int4 — Foreign key → account.id — NOT NULL — primary key, foreign key
  • name (Field) — varchar
  • currency (Field2) — varchar
  • active (Field3) — bool
  • matching_brand_id (Field4) — int4
  • exclude (Field5) — bool
  • channel_name (Field6) — varchar
  • created_time (Field7) — timestamptz

ad_performance_daily_report (광고실적 로우데이터)

  • id (Key3) — int4 — Primary key — NOT NULL — primary key
  • date (Key4) — date — Primary key — NOT NULL — unique key
  • extra_channel_unique_value (Key5) — varchar — Primary key — unique key (nullable)
  • ad_id (Key) — varchar — Foreign key → ad.id — NOT NULL — unique key, foreign key
  • ad_group_id (Key2) — varchar — Foreign key → ad.ad_group_id — NOT NULL — unique key, foreign key
  • click (Field) — int8
  • purchase_conversion (Field2) — int8
  • purchase_conversion_value (Field3) — int8
  • install_conversion (Field4) — int8
  • cost (Field5) — float8
  • cpc (Field6) — float8
  • cpm (Field7) — float8
  • ctr (Field8) — float8
  • impression (Field9) — int8
  • created_time (Field11) — timestamptz

brand (Untitled9)

  • id (Key) — int4 — Primary key — NOT NULL — primary key
  • company_id (pk) — int4 — Foreign key → company.id — foreign key
  • name (Field2) — varchar
  • seller_shipping_fee (Field) — int4
  • custom_amount_rate (Field3) — float8
  • created_time (Field4) — timestamptz

company

  • id (pk) — int4 — Primary key — primary key
  • name (Field) — varchar
  • active (Field2) — bool
  • created_time (Field3) — timestamptz
  • payment_status (Field4) — varchar
  • free_plan_end_date (Field5) — date
  • regular_payment_date (Field6) — int4

order (주문서 데이터)

  • id (Key) — varchar — Primary key — NOT NULL — primary key
  • account_id (pk) — int4 — Foreign key → account.id — NOT NULL — primary key
  • total_seller_distcount (Field) — float8
  • shipping_fee (Field2) — float8
  • address (Field3) — varchar
  • zip_code (Field4) — varchar
  • receiver (Field5) — varchar
  • receiver_contact (Field6) — varchar
  • buyer (Field7) — varchar
  • buyer_contact (Field8) — varchar
  • order_date (Field9) — timestamp
  • channel_name (Field10) — varchar
  • created_time (Field11) — timestamptz

order_item (상세주문 데이터 (판매실적 로우데이터))

  • id (Key) — varchar — Primary key — NOT NULL — primary key
  • order_id (Key2) — varchar — Foreign key → order.id — NOT NULL — primary key
  • account_id (pk) — int4 — Foreign key → order.account_id — NOT NULL — primary key
  • registered_product_option_name (Key3) — varchar — Foreign key → registered_product_option.name — NOT NULL — foreign key
  • registered_product_id (Key22) — varchar — Foreign key → registered_product_option.registered_product_id — NOT NULL — foreign key
  • channel_name (Field2) — varchar
  • status (Field3) — varchar
  • seller_discount (Field) — float8
  • seller_shipping_fee (Field4) — float8
  • sales (Field5) — float8
  • product_discount (Field6) — float8
  • product_price (Field7) — float8
  • quantity (Field8) — int4
  • actual_payment_amount (Field9) — float8
  • commission (Field10) — float8
  • vendor_item_id (Field11) — varchar
  • exposed_product_id (Field12) — varchar
  • individual_shipping_fee (Field13) — float8
  • shipping_fee (Field14) — float8
  • points_discount (Field15) — float8
  • coupon_discont (Field16) — float8
  • membership_discount (Field17) — float8
  • deposit (Field18) — float8
  • app_discount (Field19) — float8
  • shipping_discount (Field20) — float8
  • cogs (Field21) — int8
  • order_date (Field22) — timestamp
  • payment_date (Field23) — timestamp
  • delivery_start_date (Field24) — timestamp
  • delivery_completion_date (Field25) — timestamp
  • created_time (Field26) — timestamptz
  • refund_date (Field27) — timestamp
  • refund_payment_amount (Field28) — float8

registered_product (제품 데이터)

  • id (Key) — varchar — Primary key — NOT NULL — primary key
  • account_id (pk) — int4 — Foreign key → account.id — NOT NULL — primary key
  • brand_id (Field) — int4
  • name (Field2) — varchar
  • landing_url (Field3) — varchar
  • channel_name (Field4) — varchar
  • created_time (Field5)

registered_product_option (제품에 대한 옵션 데이터)

  • name (Key) — varchar — Primary key — NOT NULL — primary key
  • registered_product_id (Key2) — varchar — Foreign key → registered_product.id — NOT NULL — primary key
  • account_id (pk) — int4 — Foreign key → registered_product.account_id — NOT NULL — primary key
  • cogs (Field) — int4
  • sku (Field2) — varchar
  • channel_cogs (Field3) — int4
  • created_time (Field4) — timestamptz