autoBidingBackend_물리
테이블 (17)
active_history
- id — BIGINT — 기본 키 — NOT NULL
- ad_type — VARCHAR(255)
- custom_id — VARCHAR(255)
- advertiser_name — VARCHAR(255)
- ncc_campaign_id — VARCHAR(255)
- ncc_campaign_name — VARCHAR(255)
- ncc_adgroup_id — VARCHAR(255)
- ncc_adgroup_name — VARCHAR(255)
- keyword — VARCHAR(255)
- ncc_keyword_id — VARCHAR(255)
- action_type — VARCHAR(255)
- user_id — BIGINT
- user_email — VARCHAR(255)
- user_role — VARCHAR(255)
- created_at — DATETIME(6)
ad
- id — BIGINT — 기본 키 — NOT NULL
- ncc_adgroup_id — VARCHAR(255)
- ncc_ad_id — VARCHAR(255)
- type — VARCHAR(255)
- product_name — VARCHAR(255)
- shopping_keyword — VARCHAR(255)
- bid_amt — INT
- use_group_bid_amt — INT
- custom_id — VARCHAR(255)
- target_rank — INT
- min_bid_amt — INT
- max_bid_amt — INT
- variance — INT
- target_hit_count — INT
- previous_position — INT
- current_position — INT
- previous_bid_amt — INT
- user_lock — VARCHAR(255)
- inspect_status — VARCHAR(255)
- bid_enabled — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
ad_stat
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255) — NOT NULL
- ncc_ad_id — VARCHAR(255) — NOT NULL
- stat_date — DATE — NOT NULL
- imp_cnt — BIGINT
- clk_cnt — BIGINT
- sales_amt — BIGINT
- ccnt — BIGINT
- conv_amt — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
adgroup
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255)
- ncc_campaign_id — VARCHAR(255)
- ncc_campaign_name — VARCHAR(255)
- ncc_adgroup_id — VARCHAR(255)
- ncc_adgroup_name — VARCHAR(255)
- is_active — VARCHAR(255)
- is_connected — VARCHAR(255)
- device — VARCHAR(255)
- delay — INT
- location_id — BIGINT — 외래 키 → location.id
- is_scheduled — VARCHAR(255)
- cost_last_7_days — BIGINT
- cost_updated_at — DATETIME(6)
- last_bid_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- advertise_url — VARCHAR(255)
adgroup_schedule
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(50) — NOT NULL
- ncc_adgroup_id — VARCHAR(50) — NOT NULL
- ad_type — VARCHAR(20) — NOT NULL
- day_of_week — INT — NOT NULL
- hour_slot — INT — NOT NULL
- device — VARCHAR(10) — NOT NULL
- target_rank — INT — NOT NULL
- max_bid_amt — INT — NOT NULL
- min_bid_amt — INT — NOT NULL
- variance — INT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
advertiser
- id — BIGINT — 기본 키 — NOT NULL
- api_config_id — BIGINT
- advertiser_name — VARCHAR(255) — NOT NULL
- custom_id — VARCHAR(255)
- naver_id — VARCHAR(255)
- naver_access_license — VARCHAR(255)
- naver_secret_key — VARCHAR(255)
- naver_ad_account_no — VARCHAR(255)
- naver_ad_account_name — VARCHAR(255)
- bid_count_per_interval — INT — NOT NULL
- bid_interval_minutes — INT — NOT NULL
- power_process_enabled — BIT(1) — NOT NULL
- shopping_process_enabled — BIT(1) — NOT NULL
- last_scheduled_at — DATETIME(6)
- power_rank1_enabled — BIT(1) — NOT NULL
- power_rank2_enabled — BIT(1) — NOT NULL
- power_rank3_enabled — BIT(1) — NOT NULL
- power_rank4_enabled — BIT(1) — NOT NULL
- power_rank5_enabled — BIT(1) — NOT NULL
- shopping_rank1_enabled — BIT(1) — NOT NULL
- shopping_rank2_enabled — BIT(1) — NOT NULL
- shopping_rank3_enabled — BIT(1) — NOT NULL
- shopping_rank4_enabled — BIT(1) — NOT NULL
- shopping_rank5_enabled — BIT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
api_config
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255)
- naver_id — VARCHAR(255)
- access_license — VARCHAR(255)
- secret_key — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
bid_history
- id — BIGINT — 기본 키 — NOT NULL
- ad_type — VARCHAR(255)
- naver_ad_account_name — VARCHAR(255)
- bid_type — VARCHAR(255)
- previous_position — INT
- current_position — INT
- custom_id — VARCHAR(255)
- ncc_campaign_id — VARCHAR(255)
- ncc_campaign_name — VARCHAR(255)
- ncc_adgroup_id — VARCHAR(255)
- ncc_adgroup_name — VARCHAR(255)
- keyword — VARCHAR(255)
- keyword_id — VARCHAR(255)
- ncc_keyword_id — VARCHAR(255)
- old_bid_amt — INT
- new_bid_amt — INT
- reason — VARCHAR(255)
- target_rank — INT
- ncc_ad_id — VARCHAR(255)
- product_name — VARCHAR(255)
- bid_success — BIT(1)
- status_reason — VARCHAR(255)
- status_message — VARCHAR(255)
- created_at — DATETIME(6)
campaign
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255) — NOT NULL
- ncc_campaign_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- campaign_tp — VARCHAR(255)
- user_lock — VARCHAR(255)
- daily_budget — BIGINT
- delivery_method — VARCHAR(255)
- status — VARCHAR(255)
- status_reason — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
department
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
keyword
- id — BIGINT — 기본 키 — NOT NULL
- ncc_adgroup_id — VARCHAR(255)
- ncc_keyword_id — VARCHAR(255)
- keyword — VARCHAR(255)
- bid_amt — INT
- use_group_bid_amt — INT
- custom_id — VARCHAR(255)
- target_rank — INT
- min_bid_amt — INT
- max_bid_amt — INT
- variance — INT
- target_hit_count — INT
- previous_position — INT
- current_position — INT
- previous_bid_amt — INT
- user_lock — VARCHAR(255)
- inspect_status — VARCHAR(255)
- bid_enabled — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
keyword_stat
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255) — NOT NULL
- ncc_keyword_id — VARCHAR(255) — NOT NULL
- stat_date — DATE — NOT NULL
- imp_cnt — BIGINT
- clk_cnt — BIGINT
- sales_amt — BIGINT
- ccnt — BIGINT
- conv_amt — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
location
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
search_keyword_stat
- id — BIGINT — 기본 키 — NOT NULL
- custom_id — VARCHAR(255) — NOT NULL
- ncc_ad_id — VARCHAR(255) — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- stat_date — DATE — NOT NULL
- imp_cnt — BIGINT
- clk_cnt — BIGINT
- cost — BIGINT
- conv_cnt — BIGINT
- created_at — DATETIME(6)
setting_history
- id — BIGINT — 기본 키 — NOT NULL
- ad_type — VARCHAR(255)
- custom_id — VARCHAR(255)
- ncc_campaign_id — VARCHAR(255)
- ncc_campaign_name — VARCHAR(255)
- ncc_adgroup_id — VARCHAR(255)
- ncc_adgroup_name — VARCHAR(255)
- keyword — VARCHAR(255)
- ncc_keyword_id — VARCHAR(255)
- setting_type — VARCHAR(255)
- old_value — VARCHAR(255)
- new_value — VARCHAR(255)
- reason — VARCHAR(255)
- target_type — VARCHAR(255)
- apply_type — VARCHAR(255)
- target_count — INT
- user_id — BIGINT
- user_email — VARCHAR(255)
- user_role — VARCHAR(255)
- created_at — DATETIME(6)
user_role
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- advertiser_id — BIGINT — 외래 키 → advertiser.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(255) — NOT NULL
- role — VARCHAR(20)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- department_id — BIGINT — 외래 키 → department.id
- password_change_required — BIT(1) — NOT NULL
- password_changed_at — DATETIME(6)
- logout_at — DATETIME(6)