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