BLOOM
Tables (12)
admins
- id — UUID — Foreign key
- first_name — VARCHAR(100)
- last_name — VARCHAR(100)
- perm_level — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
amazon_tokens
- id — UUID
- brand_id — UUID — Foreign key — NOT NULL
- selling_partner_id — VARCHAR(255) — NOT NULL
- refresh_token — TEXT — NOT NULL
- region — VARCHAR(10)
brand_assignments
- id — UUID
- admin_id — UUID — Foreign key — NOT NULL
- brand_id — UUID — Foreign key — NOT NULL
- assigned_by — UUID — Foreign key
- assigned_at — TIMESTAMP — NOT NULL
campaign_applications
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- campaign_id — INT — Foreign key → campaigns.id — NOT NULL
- status — TEXT — NOT NULL
- applied_at — TIMESTAMPTZ
campaign_favorites
- id — UUID
- user_id — UUID — Foreign key — NOT NULL
- campaign_id — INT — Foreign key — NOT NULL
- created_at — TIMESTAMP
campaign_posts
- id — UUID
- user_id — UUID — Foreign key — NOT NULL
- campaign_id — INT — Foreign key — NOT NULL
- title — VARCHAR(255)
- status — VARCHAR(50)
- tiktok_video_url — TEXT
- posted_at — TIMESTAMP
campaigns
- id — SERIAL
- name — TEXT
- brand_owner_id — UUID — Foreign key → users.id
- created_by — UUID — Foreign key → users.id
- asin — TEXT
- max_applicants — INT
- created_at — TIMESTAMPTZ
notifications
- id — UUID
- user_id — UUID — NOT NULL
- type — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMPTZ
products
- id — UUID
- brand_id — UUID — Foreign key — NOT NULL
- sku — VARCHAR(100)
- asin — VARCHAR(100)
- name_kor — VARCHAR(255)
- price — DECIMAL
tiktok_tokens
- id — UUID
- user_id — UUID — Foreign key — NOT NULL
- access_token — TEXT — NOT NULL
- refresh_token — TEXT — NOT NULL
- access_token_expires_at — TIMESTAMP — NOT NULL
user_profiles
- user_id — UUID — Foreign key
- first_name — VARCHAR(100)
- last_name — VARCHAR(100)
- brand_name — VARCHAR(255)
- agency_name — VARCHAR(255)
- agency_id — UUID — Foreign key
- membership_level — VARCHAR(50)
- tiktok_username — VARCHAR(100)
- tiktok_followers_count — INT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — UUID
- email — TEXT — NOT NULL
- role — TEXT — NOT NULL
- is_verified — BOOLEAN
- created_at — TIMESTAMPTZ