k-culture dev ERD

Tables (32)

Actor_tags (Untitled10)

    Actors (Untitled2)

    • id (Key) — Primary key — NOT NULL
    • user_id (Key3) — Foreign key → Users.id — NOT NULL
    • agency (Field) — String
    • bio (Field2) — String
    • height (Field3) — Int
    • weight (Field5) — Int
    • phone (Field4) — String
    • position (Field6) — String
    • fee (Field7) — String

    Agencies (Untitled3)

    • id (Key) — Primary key — NOT NULL
    • user_id (Key2) — Foreign key → Users.id — NOT NULL
    • foundedYear (Field) — Date
    • representativeName (Field2) — String
    • specialties (Field3) — String[] — 분야

    Agency_tags (Untitled11)

      BaseTable (Untitled14)

      • createdAt (Field)
      • createdBy (Field2)
      • updatedAt (Field3)
      • updatedBY (Field4)
      • stcd (Field5) — 상태코드

      Casting (Untitled15)

      • id (Key) — Primary key — NOT NULL
      • project_id (Key2) — Foreign key → Projects.id — NOT NULL
      • character_id (Key3) — Foreign key → Characters.id — NOT NULL
      • actor_id (Key4) — Foreign key → Actors.id — NOT NULL
      • initiated_by (Field) — enum — Agency / Actor
      • status (Field2) — enum — 제안/수락/거절/취소
      • note (Field4) — 기타, 메모
      • responded_at (Field3) — DateTime

      Characters (Untitled5)

      • id (Key) — Primary key — NOT NULL
      • project_id (Key3) — Foreign key → Projects.id — NOT NULL
      • actor_id (Key2) — Foreign key → Actors.id — NOT NULL
      • name (Field) — String — NOT NULL
      • gender (Field2) — String — NOT NULL
      • roleType (Field3) — String — NOT NULL
      • ageRange (Field4) — String
      • description (Field5) — String
      • keywords (Field6) — String[]
      • specialTags (Field7) — String[]

      Favorites (Untitled8)

      • id (Key) — Primary key — NOT NULL
      • user_id (Key3) — Foreign key → Users.id — NOT NULL
      • target_id (Field2) — actor_id / project_id
      • type (Field) — enum — actor/project

      Filmography (Untitled6)

      • id (Key) — Primary key — NOT NULL
      • actor_id (Key3) — Foreign key → Actors.id — NOT NULL
      • title (Field) — String — NOT NULL
      • type (Field2) — enum — NOT NULL
      • year (Field3) — Int — NOT NULL
      • role (Field4) — enum — NOT NULL
      • thumbnail (Field5) — url

      Notification_settings (Untitled9)

      • id (Key) — Primary key — NOT NULL
      • user_id (Key3) — Foreign key → Users.id — NOT NULL
      • castingNotification (Field) — Boolean — 캐스팅 제안
      • marketingNotification (Field2) — Boolean — 마케팅
      • messageNotification (Field3) — Boolean — 메시지

      Project_tags (Untitled13)

        Projects (Untitled4)

        • id (Key) — Primary key — NOT NULL
        • agency_id (Key3) — Foreign key → Agencies.id — NOT NULL
        • status (Field) — enum — NOT NULL
        • company (Field2) — String — NOT NULL
        • genre (Field4) — String
        • project_type (Field5) — String
        • characters (Field9)
        • roleInfo (Field6) — String
        • shootingPeriod (Field7) — String

        Showreels (Untitled7)

        • id (Key) — Primary key — NOT NULL
        • actor_id (Key3) — Foreign key → Actors.id — NOT NULL
        • Duration (Field) — String
        • genre (Field2) — String
        • representativeGenre (Field3) — String — 필요한가?
        • role (Field4) — String
        • tags (Field5) — String[]
        • thumbnail (Field6) — url
        • videoUrl (Field7) — url — NOT NULL
        • workTitle (Field8) — String — ?
        • year (Field9) — Int

        Tags (Untitled12)

          Users (Untitled)

          • id (Key) — Primary key — NOT NULL
          • uuid (Field6) — uuid
          • email (Field) — String
          • name (Field2) — String
          • type (Field3) — enum — actor/agency
          • profileImage (Field5) — url
          • phoneNumber (Field7) — String

          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 — Primary key — NOT NULL
          • 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