ads
Tables (17)
ad_collection
- ad_collection_id — BIGINT
- collection_type — VARCHAR(255)
- name — VARCHAR(255)
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- ad_group_status — VARCHAR(255)
- business_group_id — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ad_group
- ad_group_id — BIGINT
- ad_collection_id — BIGINT — NOT NULL
- campaign_id — BIGINT — NOT NULL
- target_id — BIGINT — NOT NULL
- daily_budget — BIGINT
ad_group_budget
- id — BIGINT
- ad_group_id — BIGINT — NOT NULL
- version — BIGINT
- amount — BIGINT
- deposit_sum — BIGINT
- withdraw_sum — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
bottom_sheet_ad
- bottom_sheet_ad_id — BIGINT
- ad_collection_id — BIGINT — NOT NULL
- name — VARCHAR(255)
- category — VARCHAR(255)
- ad_status — VARCHAR(255)
- brand_name — VARCHAR(255)
- background_image — TEXT
- title — VARCHAR(255)
- sub_title — VARCHAR(255)
- cta_button_text — VARCHAR(255)
- cta_button_text_color — VARCHAR(7)
- hide_today_button_text_color — VARCHAR(7)
- cta_button_color — VARCHAR(7)
- cta_button_link — TEXT
- close_icon_url — TEXT
- is_web_link — BOOLEAN
- is_app_screen — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
business_group
- business_group_id — BIGINT
- company_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_agency — BOOLEAN
- invoice_email — VARCHAR(255)
- review_status — VARCHAR(40)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
campaign
- campaign_id — BIGINT
- business_group_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- budget — DOUBLE
- campaign_status — VARCHAR(255)
- goal — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
campaign_budget
- campaign_budget_id — BIGINT
- campaign_id — BIGINT — NOT NULL
- version — BIGINT
- paid_amount — BIGINT
- paid_deposit_sum — BIGINT
- paid_withdraw_sum — BIGINT
- free_amount — BIGINT
- free_deposit_sum — BIGINT
- free_withdraw_sum — BIGINT
- is_postpaid — BOOLEAN
- credit_limit — BIGINT
- credit_deposit_sum — BIGINT
- credit_withdraw_sum — BIGINT
- credit_settlement_sum — BIGINT
- billing_due_date — TIMESTAMP
- billing_status — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
company
- company_id — BIGINT
- registration_number — VARCHAR(255) — NOT NULL
- registration_image_url — VARCHAR(255)
- business_account_image_url — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- representative_name — VARCHAR(255)
- type — VARCHAR(255)
- industry — VARCHAR(255)
- address — VARCHAR(255)
- zip_code — VARCHAR(255)
- account_number — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
member
- member_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- account_id — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
member_business_group
- id — BIGINT — Primary key — NOT NULL — ID
- member_id — BIGINT — NOT NULL — 회원 ID
- business_group_id — BIGINT — NOT NULL — 비즈니스 그룹 ID
- role — VARCHAR(255) — NOT NULL — 역할
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
- ad_group_id — BIGINT — NOT NULL — 광고그룹 ID
- name — VARCHAR(255) — NOT NULL — 광고명
- category — VARCHAR(255) — NOT NULL — 카테고리
- ad_status — VARCHAR(255) — NOT NULL — 광고 상태
- brand_name — VARCHAR(255) — NOT NULL — 브랜드명
- icon_image_url — VARCHAR(255) — NOT NULL — 아이콘 이미지 URL
- landing_url — TEXT — NOT NULL — 랜딩 URL
- main_text — TEXT — NOT NULL — 메인 텍스트
- sub_text — TEXT — NOT NULL — 서브 텍스트
- cta_button_text — VARCHAR(255) — NOT NULL — CTA 버튼 텍스트
- requires_review — VARCHAR(255) — 검토 필요 여부
- detargeting_condition — TEXT — 디타겟팅 조건
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
- ad_group_id — BIGINT — NOT NULL — 광고그룹 ID
- name — VARCHAR(255) — NOT NULL — 광고명
- category — VARCHAR(255) — NOT NULL — 카테고리
- ad_status — VARCHAR(255) — NOT NULL — 광고 상태
- image_url — VARCHAR(2048) — NOT NULL — 이미지 URL
- landing_url — TEXT — NOT NULL — 랜딩 URL
- brand_name — TEXT — NOT NULL — 브랜드명
- requires_review — VARCHAR(255) — 검토 필요 여부
- detargeting_condition — TEXT — 디타겟팅 조건
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
- ad_collection_id — BIGINT — NOT NULL — 광고 컬렉션 ID
- name — VARCHAR(255) — NOT NULL — 광고명
- category — VARCHAR(255) — NOT NULL — 카테고리
- ad_status — VARCHAR(255) — NOT NULL — 광고 상태
- brand_name — VARCHAR(255) — NOT NULL — 브랜드명
- background_image — TEXT — NOT NULL — 배경 이미지
- is_web_link — BOOLEAN — NOT NULL — 웹 링크 여부
- is_app_screen — BOOLEAN — NOT NULL — 앱 화면 여부
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
- name — VARCHAR(255) — NOT NULL — 전략명
- device — VARCHAR(255) — NOT NULL — 디바이스
- gender — VARCHAR(255) — NOT NULL — 성별
- min — INT — 최소 연령
- max — INT — 최대 연령
- is_all — BOOLEAN — NOT NULL — 전체 연령 여부
- business_group_id — BIGINT — NOT NULL — 비즈니스 그룹 ID
- is_all_placements — BOOLEAN — NOT NULL — 전체 플레이스먼트 여부
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — NOT NULL — 수정일시
mission
- mission_id — BIGINT
- mission_ad_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
mission_ad
- mission_ad_id — BIGINT
- ad_collection_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
mission_comment
- mission_comment_id — BIGINT
- mission_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
native_banner_ad
- native_banner_ad_id — BIGINT
- ad_group_id — BIGINT — NOT NULL
- name — VARCHAR(255)
- category — VARCHAR(255)
- ad_status — VARCHAR(255)
- brand_name — VARCHAR(255)
- icon_image_url — VARCHAR(255)
- landing_url — TEXT
- main_text — TEXT
- sub_text — TEXT
- cta_button_text — VARCHAR(255)
- requires_review — VARCHAR(255)
- detargeting_condition — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
rectangular_banner_ad
- rectangular_banner_ad_id — BIGINT
- ad_group_id — BIGINT — NOT NULL
- name — VARCHAR(255)
- category — VARCHAR(255)
- ad_status — VARCHAR(255)
- image_url — VARCHAR(2048)
- landing_url — TEXT
- brand_name — TEXT
- requires_review — VARCHAR(255)
- detargeting_condition — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
splash_sheet_ad
- splash_sheet_ad_id — BIGINT
- ad_collection_id — BIGINT — NOT NULL
- name — VARCHAR(255)
- category — VARCHAR(255)
- ad_status — VARCHAR(255)
- brand_name — VARCHAR(255)
- background_image — TEXT
- is_web_link — BOOLEAN
- is_app_screen — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
target_strategy
- ad_group_target — BIGINT
- name — VARCHAR(255)
- device — VARCHAR(255)
- gender — VARCHAR(255)
- min — INT
- max — INT
- is_all — BOOLEAN
- business_group_id — BIGINT
- is_all_placements — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP