castup-draft
Tables (31)
announcement_casting_roles
- id (casting_role_id) — UUID — Primary key — NOT NULL
- id (annoucement_id) — UUID — Foreign key → announcements.id — NOT NULL
- name (role_name)
- gender — ENUM('ALL','MALE','FEMALE')
- min_age
- max_age
- description
announcement_photos
- id (annoucement_id) — UUID — Foreign key → announcements.id — NOT NULL
- id (photo_id) — UUID — Foreign key → photo.id — NOT NULL
announcement_user_actor_applications
- id (application_id) — Primary key — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- id (casting_role_id) — UUID — Foreign key → announcement_casting_roles.id — NOT NULL
- is_checked — BOOLEAN
- audition_status — ENUM('지원완료','오디션','최종합격','종료')
announcements
- id (annoucement_id) — UUID — Primary key — NOT NULL
- category — ENUM('영화','드라마',..)
- work_title
- production
- director
- manager
- title
- description
- is_uploaded — BOOLEAN
- due_at
- created_at
- updated_at
- id (production_id) — UUID — Foreign key → productions.id — NOT NULL
application_auditions
- id (audition_id) — UUID — Primary key — NOT NULL
- id (application_id) — Foreign key → announcement_user_actor_applications.id — NOT NULL
- scheduled_at
- is_confirmed — BOOLEAN
info_tags
- id (info_id) — Foreign key → infos.id — NOT NULL
- id (tag_id) — Foreign key → tag.id — NOT NULL
infos
- id (info_id) — Primary key — NOT NULL
- category — ENUM('정부지원','아르바이트') — NOT NULL
- title — VARCHAR() — NOT NULL
- description — TEXT — NOT NULL
- url — VARCHAR() — NOT NULL
- deadline
- is_new — BOOLEAN — NOT NULL
- created_at — NOT NULL
- updated_at
photo
- id (photo_id) — UUID — Primary key — NOT NULL
- url
- created_at
- updated_at
productions
- id (production_id) — UUID — Primary key — NOT NULL
- name
- founded_at
- address
script_lines
- id (line_id) — UUID — Primary key — NOT NULL
- id (script_id) — UUID — Foreign key → scripts.id — NOT NULL
- role
- expression
- line
script_tags
- id (script_id) — UUID — Foreign key → scripts.id — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- name
scripts
- id (script_id) — UUID — Primary key — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- title
- category
- created_at
skill
- id (skill_id) — UUID — Primary key — NOT NULL
- type — ENUM('음악','퍼포먼스','언어'','스포츠',,'기타') — NOT NULL
- category — VARCHAR() — NOT NULL
style
- id (style_id) — UUID — Primary key — NOT NULL
- type — ENUM('얼굴형','체형','피부톤','음색','타투','분위기')
- category — VARCHAR()
tag
- id (tag_id) — Primary key — NOT NULL
- tag — ENU M('창작지원','예술인','제작비'...)
user
- id (user_id) — UUID — Primary key — NOT NULL
- email
- password — VARCHAR()
- user_name
- phone_number
- created_at
- updated_at
- role — ENUM('배우','캐스팅디렉터','감독')
user_actor
- id (user_id) — UUID — Foreign key → user.id — NOT NULL
- name
- birth_date
- gender — ENUM('남','여')
- height
- weight
- education
- sns_url
- star_score
- qr_url (castup_card_qr_url)
user_actor_detail
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- introduction — TEXT
- qr_url (castup_card_qr_url)
user_actor_experience
- id (experience_id) — UUID — Primary key — NOT NULL
- type — ENUM('드라마','영화','연극','수상')
- filmed_year
- title
- production
- director
- role_type — ENUM('주연','조연','목소리출연'...)
- description — VARCHAR()
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
user_actor_experience_photos
- id (experience_id) — UUID — Foreign key → user_actor_experience.id — NOT NULL
- id (photo_id) — UUID — Foreign key → photo.id — NOT NULL
user_actor_notification_setting_type
- id (type_id) — UUID — Primary key — NOT NULL
- type
user_actor_notification_settings
- id (type_id) — UUID — Foreign key → user_actor_notification_setting_type.id — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- is_on — BOOLEAN
user_actor_notifications
- id (notification_id) — UUID — Primary key — NOT NULL
- type — ENUM('일반, '오디션', '프로필 투어') — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- is_expired — BOOLEAN
- created_at — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
user_actor_photos
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- id (photo_id) — UUID — Foreign key → photo.id — NOT NULL
- type — ENUM('대표','일반')
user_actor_production_profile_submissions
- id (production_id) — UUID — Foreign key → productions.id — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- is_checked — BOOLEAN
- submitted_at
user_actor_skills
- id (skill_id) — UUID — Foreign key — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
user_actor_styles
- id (style_id) — UUID — Foreign key → style.id — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
user_actor_videos
- id (user_id) — UUID — Foreign key → user_actor.id — NOT NULL
- id (video_id) — UUID — Foreign key → video.id — NOT NULL
- type — ENUM('대표','일반')
- title — VARCHAR()
- work_title
- category — ENUM('영화','드라마','연극','뮤지컬','숏폼/숏드라마','방송')
- id (thumbnail_photo_id) — UUID — Foreign key → photo.id — NOT NULL
user_actor_videos_genres
- id (video_id) — UUID — Foreign key → user_actor_videos.id — NOT NULL
- id (user_id) — UUID — Foreign key → user_actor_videos.id — NOT NULL
- id (genre_id) — UUID — Foreign key → video_genres.id — NOT NULL
video
- id (video_id) — UUID — Primary key — NOT NULL
- url
- created_at
- updated_at
video_genres
- id (genre_id) — UUID — Primary key — NOT NULL
- genre — ENUM('멜로','로맨스','액션','판타지','코미디'...)