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