k-culture temp
Tables (17)
actor_filmography
- id — BIGSERIAL
- actor_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- work_type — VARCHAR(30) — NOT NULL
- role_name — VARCHAR(120)
- year — INT
- note — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
actor_media
- id — BIGSERIAL
- actor_id — BIGINT — NOT NULL
- media_id — BIGINT — NOT NULL
- media_type — VARCHAR(30) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
actor_profiles
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- birth_year — INT
- gender — VARCHAR(10)
- height_cm — INT
- agency_name — VARCHAR(120)
- location_city — VARCHAR(60)
- bio — TEXT
- profile_image_media_id — BIGINT
- is_public — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
actor_tags
- id — BIGSERIAL
- actor_id — BIGINT — NOT NULL
- tag — VARCHAR(60) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
agency_profiles
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- display_name — VARCHAR(120) — NOT NULL
- contact_name — VARCHAR(80)
- contact_email — VARCHAR(255)
- contact_phone — VARCHAR(50)
- bio — TEXT
- logo_media_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
auditions
- id — BIGSERIAL
- offer_id — BIGINT — NOT NULL
- actor_id — BIGINT — NOT NULL
- media_id — BIGINT — NOT NULL
- note — TEXT
- status — VARCHAR(30) — NOT NULL
- submitted_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
casting_offers
- id — BIGSERIAL
- project_id — BIGINT — NOT NULL
- character_id — BIGINT — NOT NULL
- agency_id — BIGINT — NOT NULL
- actor_id — BIGINT — NOT NULL
- message — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
character_tags
- id — BIGSERIAL
- character_id — BIGINT — NOT NULL
- tag — VARCHAR(60) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
characters
- id — BIGSERIAL
- project_id — BIGINT — NOT NULL
- name — VARCHAR(120) — NOT NULL
- gender — VARCHAR(10)
- age_min — INT
- age_max — INT
- description — TEXT
- requirements — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
conversations
- id — BIGSERIAL
- agency_id — BIGINT — NOT NULL
- actor_id — BIGINT — NOT NULL
- last_message_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
media_files
- id — BIGSERIAL
- owner_user_id — BIGINT — NOT NULL
- storage_provider — VARCHAR(30) — NOT NULL
- bucket — VARCHAR(255) — NOT NULL
- object_key — TEXT — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- duration_sec — INT
- width — INT
- height — INT
- checksum — VARCHAR(128)
- created_at — TIMESTAMP — NOT NULL
messages
- id — BIGSERIAL
- conversation_id — BIGINT — NOT NULL
- sender_user_id — BIGINT — NOT NULL
- message_type — VARCHAR(20) — NOT NULL
- content — TEXT
- media_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
notifications
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- type — VARCHAR(30) — NOT NULL
- title — VARCHAR(120)
- body — TEXT
- link_url — TEXT
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
project_tags
- id — BIGSERIAL
- project_id — BIGINT — NOT NULL
- tag — VARCHAR(60) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
projects
- id — BIGSERIAL
- agency_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- logline — VARCHAR(300)
- synopsis — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_events
- id — BIGSERIAL
- user_id — BIGINT
- event_type — VARCHAR(60) — NOT NULL
- screen — VARCHAR(80)
- meta — JSONB
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL