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