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('멜로','로맨스','액션','판타지','코미디'...)