celeb

Tables (46)

_agency_application_profiles

  • A — INT — Foreign key → applications.id — NOT NULL
  • B — VARCHAR(191) — Foreign key → profiles.id — NOT NULL
  • INDEX — `_agency_application_profiles_B_index`

_prisma_migrations

  • id — VARCHAR(36) — Primary key — NOT NULL
  • checksum — VARCHAR(64) — NOT NULL
  • finished_at — DATETIME(3)
  • migration_name — VARCHAR(255) — NOT NULL
  • logs — TEXT
  • rolled_back_at — DATETIME(3)
  • started_at — DATETIME(3) — NOT NULL
  • applied_steps_count — INT — NOT NULL

accounts

  • id — INT — Primary key — NOT NULL
  • providerType — VARCHAR(191)
  • providerAccountId — VARCHAR(191)
  • accessToken — VARCHAR(1024)
  • refreshToken — VARCHAR(1024)
  • accessTokenExpires — DATETIME(3)
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `accounts_userId_fkey`

admin_logs

  • id — INT — Primary key — NOT NULL
  • userId — INT
  • entity — VARCHAR(191) — NOT NULL
  • entityId — VARCHAR(191) — NOT NULL
  • actionType — VARCHAR(191) — NOT NULL
  • beforeData — JSON
  • afterData — JSON
  • reason — VARCHAR(191)
  • createdAt — DATETIME(3) — NOT NULL
  • adminId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `admin_logs_adminId_fkey`

aligos

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR(191) — NOT NULL
  • content — VARCHAR(191) — NOT NULL
  • phone — VARCHAR(191) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `aligos_userId_fkey`

applications

  • id — INT — Primary key — NOT NULL
  • type — ENUM('PERSONAL', 'AGENCY', 'SUGGESTION') — NOT NULL
  • status — ENUM('DEFAULT', 'PENDING', 'READ', 'DOCUMENT_PASS', 'FINAL_PASS', 'FAIL') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • roleId — INT — Foreign key → roles.id
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • companyId — INT — Foreign key → companies.id
  • INDEX — `applications_userId_fkey`
  • INDEX — `applications_roleId_fkey`
  • INDEX — `applications_profileId_fkey`
  • INDEX — `applications_companyId_fkey`

artists

  • id — INT — Primary key — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id — NOT NULL
  • companyId — INT — Foreign key → companies.id — NOT NULL
  • INDEX — `artists_profileId_fkey`
  • INDEX — `artists_companyId_fkey`

bookmarks

  • id — INT — Primary key — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • portfolioId — VARCHAR(191) — Foreign key → portfolios.id
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id
  • magazineId — INT — Foreign key → magazines.id
  • INDEX — `user_index`
  • INDEX — `bookmarks_profileId_fkey`
  • INDEX — `bookmarks_portfolioId_fkey`
  • INDEX — `bookmarks_castingCallId_fkey`
  • INDEX — `bookmarks_magazineId_fkey`

career_details

  • id — INT — Primary key — NOT NULL
  • date — VARCHAR(191) — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • role — VARCHAR(191) — NOT NULL
  • url — VARCHAR(191)
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • careerId — INT — Foreign key → careers.id
  • INDEX — `career_details_careerId_fkey`

careers

  • id — INT — Primary key — NOT NULL
  • number — VARCHAR(191)
  • category — ENUM('MOVIE', 'DRAMA', 'MUSICAL', 'PERFORMANCE', 'WEBDRAMA', 'MUSICVIDEO', 'CF', 'ADVERTISEMENT', 'MAGAZINE', 'PICTORIAL', 'FASHIONSHOW', 'BEAUTY', 'YOUTUBE', 'PARTTIME', 'COMMERCIAL', 'INDEPENDENT', 'SHORT', 'OTT_TV', 'ETC') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • companyId — INT — Foreign key → companies.id
  • INDEX — `careers_profileId_fkey`
  • INDEX — `careers_companyId_fkey`

casting_calls

  • id — VARCHAR(191) — Primary key — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • email — VARCHAR(191) — NOT NULL
  • phone — VARCHAR(191) — NOT NULL
  • jobDescription — TEXT — NOT NULL
  • preference — TEXT — NOT NULL
  • map — VARCHAR(191)
  • recruitmentStart — DATETIME(3) — NOT NULL
  • recruitmentEnd — DATETIME(3) — NOT NULL
  • isPayment — TINYINT(1) — NOT NULL
  • category — ENUM('MOVIE', 'DRAMA', 'MUSICAL', 'PERFORMANCE', 'WEBDRAMA', 'MUSICVIDEO', 'CF', 'ADVERTISEMENT', 'MAGAZINE', 'PICTORIAL', 'FASHIONSHOW', 'BEAUTY', 'YOUTUBE', 'PARTTIME', 'COMMERCIAL', 'INDEPENDENT', 'SHORT', 'OTT_TV', 'ETC') — NOT NULL
  • showType — ENUM('PUBLIC', 'COMPANY_ONLY', 'APPLYED_ONLY', 'PRIVATE') — NOT NULL
  • support — ENUM('EMAIL', 'WEB') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `casting_calls_userId_fkey`

cfg_config_defaults

  • id — INT — Primary key — NOT NULL
  • siteUrl — TEXT
  • title — VARCHAR(255)
  • siteLogo — VARCHAR(255)
  • adminLogo — VARCHAR(255)
  • showCompanyInfo — TINYINT(1) — NOT NULL
  • wordFiltering — TEXT
  • allowIframe — TEXT
  • cooldown — INT — NOT NULL
  • pageSize — INT — NOT NULL
  • mailSendID — TEXT
  • mailSendPW — TEXT
  • mailSendSMTP — TEXT
  • mailSendSMTPort — INT
  • allowAdminIP — TEXT
  • blockIP — TEXT
  • allowIP — TEXT
  • blockMessageTitle — TEXT
  • blockMessageContent — TEXT
  • usePoint — TINYINT(1) — NOT NULL
  • joinPoint — INT — NOT NULL
  • loginPoint — INT — NOT NULL
  • joinSuggestionPoint — INT — NOT NULL
  • subscriberPoints — INT — NOT NULL
  • blockDownload — TINYINT(1) — NOT NULL
  • blockReadBoard — TINYINT(1) — NOT NULL
  • blockWriteBoard — TINYINT(1) — NOT NULL
  • noteUsepoint — TINYINT(1) — NOT NULL
  • notePcPageSize — INT — NOT NULL
  • noteMobilePageSize — INT — NOT NULL
  • CompanyName — TEXT
  • CompanyRegistrationNumber — TEXT
  • CompanyCEO — TEXT
  • CompanyPhone — TEXT
  • CompanyFAX — TEXT
  • CompanyTelecommunicationSalesBusinessReportNumber — TEXT
  • CompanyValueAddedCommunicationBusinessNumber — TEXT
  • CompanyZIPCode — TEXT
  • CompanyAddress — TEXT
  • CompanyAddressDetail — TEXT
  • CompanyInformationManagementManager — TEXT
  • CompanyInformationManagementEmail — TEXT
  • favicon — TEXT
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

cfg_config_joins

  • id — INT — Primary key — NOT NULL
  • joinBlock — TINYINT(1) — NOT NULL
  • passwordMinlength — INT — NOT NULL
  • passwordUppercase — INT — NOT NULL
  • passwordNumber — INT — NOT NULL
  • passwordSpecial — INT — NOT NULL
  • useProfile — TINYINT(1) — NOT NULL
  • profileWidth — INT — NOT NULL
  • profileHeight — INT — NOT NULL
  • useUicon — TINYINT(1) — NOT NULL
  • uiconWidth — INT — NOT NULL
  • uiconHeight — INT — NOT NULL
  • blockNickName — TEXT
  • blockEmail — TEXT
  • terms — TEXT
  • pp — TEXT
  • level — INT — NOT NULL
  • editNickCool — INT — NOT NULL
  • editOpenCool — INT — NOT NULL
  • editNoteCool — INT — NOT NULL
  • updatePasswordNeed — INT — NOT NULL
  • loginBlockcnt — INT — NOT NULL
  • loginRetrysec — INT — NOT NULL
  • loginRedirect — TEXT
  • logoutRedirect — TEXT
  • snsLogin — TINYINT(1) — NOT NULL
  • kakaoLogin — TINYINT(1) — NOT NULL
  • naverLogin — TINYINT(1) — NOT NULL
  • googleLogin — TINYINT(1) — NOT NULL
  • appleLogin — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

cfg_config_layouts

  • id — INT — Primary key — NOT NULL
  • favicon — TEXT
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

cfg_config_mails

  • id — INT — Primary key — NOT NULL
  • joinAdminSend — TINYINT(1) — NOT NULL
  • joinAdminTitle — TEXT
  • joinAdminContent — TEXT
  • joinUserTitle — TEXT
  • joinUserContent — TEXT
  • pwAdminSend — TINYINT(1) — NOT NULL
  • pwAdminTitle — TEXT
  • pwAdminContent — TEXT
  • pwUserTitle — TEXT
  • pwUserContent — TEXT
  • exitAdminSend — TINYINT(1) — NOT NULL
  • exitAdminTitle — TEXT
  • exitAdminContent — TEXT
  • exitUserTitle — TEXT
  • exitUserContent — TEXT
  • changeEmailUserTitle — TEXT
  • changeEmailUserContent — TEXT
  • findIDUserTitle — TEXT
  • findIDUserContent — TEXT
  • valiReUserTitle — TEXT
  • valiReUserContent — TEXT
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

cfg_config_metas

  • id — INT — Primary key — NOT NULL
  • title — TEXT
  • description — VARCHAR(255)
  • author — VARCHAR(255)
  • url — TEXT
  • name — TEXT
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

comments

  • id — INT — Primary key — NOT NULL
  • text — LONGTEXT — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • magazineId — INT — Foreign key → magazines.id
  • communityId — INT — Foreign key → communities.id
  • parentCommentId — INT — Foreign key → comments.id
  • INDEX — `comments_userId_fkey`
  • INDEX — `comments_magazineId_fkey`
  • INDEX — `comments_communityId_fkey`
  • INDEX — `comments_parentCommentId_fkey`

communities

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • category — ENUM('FREE', 'ANONYMOUS', 'QNA', 'FAQ', 'INFORMATION') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `communities_userId_fkey`

companies

  • id — INT — Primary key — NOT NULL
  • uniqueId — VARCHAR(191) — NOT NULL
  • ceoName — VARCHAR(191)
  • name — VARCHAR(191) — NOT NULL
  • address — VARCHAR(191) — NOT NULL
  • detailAddress — VARCHAR(191)
  • businessNumber — VARCHAR(191) — NOT NULL
  • introduction — VARCHAR(191)
  • country — VARCHAR(191)
  • industry — VARCHAR(191)
  • managerName — VARCHAR(191)
  • managerPosition — VARCHAR(191)
  • managerPhone — VARCHAR(191)
  • managerEmail — VARCHAR(191)
  • status — VARCHAR(191) — NOT NULL
  • youtube — VARCHAR(191)
  • facebook — VARCHAR(191)
  • instagram — VARCHAR(191)
  • kakaoTalk — VARCHAR(191)
  • showType — ENUM('PUBLIC', 'COMPANY_ONLY', 'APPLYED_ONLY', 'PRIVATE') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL

conditions

  • id — INT — Primary key — NOT NULL
  • role — ENUM('USER', 'BUSINESS', 'ADMIN') — NOT NULL
  • infoChecked — TINYINT(1) — NOT NULL
  • termsChecked — TINYINT(1) — NOT NULL
  • emailChecked — TINYINT(1) — NOT NULL
  • smsChecked — TINYINT(1) — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL

documents

  • id — INT — Primary key — NOT NULL
  • url — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • type — VARCHAR(191) — NOT NULL
  • originName — TEXT — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • companyId — INT — Foreign key → companies.id
  • INDEX — `documents_userId_fkey`
  • INDEX — `documents_companyId_fkey`

download_logs

  • id — INT — Primary key — NOT NULL
  • ip — VARCHAR(255) — NOT NULL
  • fileId — INT — Foreign key → upload_logs.id — NOT NULL
  • userId — INT — Foreign key → users.id
  • os — VARCHAR(255)
  • browser — VARCHAR(255)
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • INDEX — `download_logs_fileId_fkey`
  • INDEX — `download_logs_userId_fkey`

external_castings

  • id — INT — Primary key — NOT NULL
  • category — ENUM('MOVIE', 'DRAMA', 'MUSICAL', 'PERFORMANCE', 'WEBDRAMA', 'MUSICVIDEO', 'CF', 'ADVERTISEMENT', 'MAGAZINE', 'PICTORIAL', 'FASHIONSHOW', 'BEAUTY', 'YOUTUBE', 'PARTTIME', 'COMMERCIAL', 'INDEPENDENT', 'SHORT', 'OTT_TV', 'ETC') — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • castingTitle — VARCHAR(191) — NOT NULL
  • company — VARCHAR(191) — NOT NULL
  • director — VARCHAR(191) — NOT NULL
  • period — VARCHAR(191) — NOT NULL
  • recruitmentStart — DATETIME(3) — NOT NULL
  • recruitmentEnd — DATETIME(3) — NOT NULL
  • jobDescription — TEXT — NOT NULL
  • preference — TEXT — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • pay — VARCHAR(191) — NOT NULL
  • numberOfPeople — VARCHAR(191) — NOT NULL
  • managerName — VARCHAR(191) — NOT NULL
  • managerEmail — VARCHAR(191) — NOT NULL
  • managerPhoneNumber — VARCHAR(191) — NOT NULL
  • support — ENUM('EMAIL', 'WEB') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

jobs

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userDetailId — INT — Foreign key → user_details.id
  • INDEX — `jobs_userDetailId_fkey`

likes

  • id — INT — Primary key — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • portfolioId — VARCHAR(191) — Foreign key → portfolios.id
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id
  • magazineId — INT — Foreign key → magazines.id
  • communityId — INT — Foreign key → communities.id
  • commentId — INT — Foreign key → comments.id
  • INDEX — `user_index`
  • INDEX — `community_index`
  • INDEX — `comment_index`
  • INDEX — `likes_profileId_fkey`
  • INDEX — `likes_portfolioId_fkey`
  • INDEX — `likes_castingCallId_fkey`
  • INDEX — `likes_magazineId_fkey`

magazines

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(191)
  • content — LONGTEXT
  • link — TEXT
  • category — ENUM('MODEL', 'ACTOR', 'TIP', 'INTERVIEW', 'PROMOTION', 'LOOKBOOK', 'VIDEO') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • randomValue — DOUBLE — NOT NULL
  • INDEX — `random_value_index`
  • INDEX — `magazines_userId_fkey`

notifications

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • message — LONGTEXT — NOT NULL
  • link — VARCHAR(191)
  • read — TINYINT(1) — NOT NULL
  • type — ENUM('NEWS_UPDATE', 'USER_INFO', 'PLATFORM_UPDATE', 'EVENT_REMINDER', 'SYSTEM_MESSAGE') — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `notifications_userId_fkey`

password_change_logs

  • id — INT — Primary key — NOT NULL
  • ip — VARCHAR(191)
  • userAgent — VARCHAR(191)
  • changedAt — DATETIME(3) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `password_change_logs_userId_fkey`

password_reset_tokens

  • id — INT — Primary key — NOT NULL
  • token — VARCHAR(191) — NOT NULL
  • expiresAt — DATETIME(3) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL

payment_methods

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR(191) — NOT NULL

payments

  • id — INT — Primary key — NOT NULL
  • amount — DOUBLE — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED', 'FAILED') — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id — NOT NULL
  • paymentMethodId — INT — Foreign key → payment_methods.id — NOT NULL
  • INDEX — `payments_userId_fkey`
  • INDEX — `payments_castingCallId_fkey`
  • INDEX — `payments_paymentMethodId_fkey`

photos

  • id — INT — Primary key — NOT NULL
  • url — TEXT — NOT NULL
  • type — VARCHAR(191) — NOT NULL
  • originName — TEXT — NOT NULL
  • isMain — TINYINT(1) — NOT NULL
  • isBanner — TINYINT(1) — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • showType — ENUM('PUBLIC', 'COMPANY_ONLY', 'APPLYED_ONLY', 'PRIVATE') — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • accountId — INT — Foreign key → accounts.id
  • magazineId — INT — Foreign key → magazines.id
  • companyId — INT — Foreign key → companies.id
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • portfolioId — VARCHAR(191) — Foreign key → portfolios.id
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id
  • randomValue — DOUBLE — NOT NULL
  • height — DOUBLE — NOT NULL
  • width — DOUBLE — NOT NULL
  • INDEX — `random_value_index`
  • INDEX — `photos_userId_fkey`
  • INDEX — `photos_companyId_fkey`
  • INDEX — `photos_profileId_fkey`
  • INDEX — `photos_portfolioId_fkey`
  • INDEX — `photos_castingCallId_fkey`

portfolios

  • id — VARCHAR(191) — Primary key — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • category — ENUM('MOVIE', 'DRAMA', 'MUSICAL', 'PERFORMANCE', 'WEBDRAMA', 'MUSICVIDEO', 'CF', 'ADVERTISEMENT', 'MAGAZINE', 'PICTORIAL', 'FASHIONSHOW', 'BEAUTY', 'YOUTUBE', 'PARTTIME', 'COMMERCIAL', 'INDEPENDENT', 'SHORT', 'OTT_TV', 'ETC') — NOT NULL
  • showType — ENUM('PUBLIC', 'COMPANY_ONLY', 'APPLYED_ONLY', 'PRIVATE') — NOT NULL
  • creatorType — ENUM('USER', 'COMPANY') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • randomValue — DOUBLE — NOT NULL
  • INDEX — `random_value_index`
  • INDEX — `portfolios_userId_fkey`

profiles

  • id — VARCHAR(191) — Primary key — NOT NULL
  • title — VARCHAR(191) — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • grade — INT — NOT NULL
  • agency — VARCHAR(191)
  • birthday — VARCHAR(191)
  • height — VARCHAR(191)
  • weight — VARCHAR(191)
  • facebook — VARCHAR(191)
  • youtube — VARCHAR(191)
  • kakaoTalk — VARCHAR(191)
  • instagram — VARCHAR(191)
  • phone — VARCHAR(191)
  • showType — ENUM('PUBLIC', 'COMPANY_ONLY', 'APPLYED_ONLY', 'PRIVATE') — NOT NULL
  • creatorType — ENUM('USER', 'COMPANY') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • randomValue — DOUBLE — NOT NULL
  • INDEX — `random_value_index`
  • INDEX — `profiles_userId_fkey`

proposals

  • id — INT — Primary key — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • proposerId — INT — Foreign key → users.id — NOT NULL
  • receiverId — INT — Foreign key → users.id — NOT NULL
  • currentRoleId — INT — Foreign key → roles.id — NOT NULL
  • proposedRoleId — INT — Foreign key → roles.id — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • INDEX — `proposals_proposerId_fkey`
  • INDEX — `proposals_receiverId_fkey`
  • INDEX — `proposals_currentRoleId_fkey`
  • INDEX — `proposals_proposedRoleId_fkey`
  • INDEX — `proposals_profileId_fkey`

roles

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • minAge — VARCHAR(191) — NOT NULL
  • maxAge — VARCHAR(191) — NOT NULL
  • count — VARCHAR(191) — NOT NULL
  • pay — VARCHAR(191) — NOT NULL
  • description — TEXT — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id — NOT NULL
  • INDEX — `roles_castingCallId_fkey`

skills

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • roleId — INT — Foreign key → roles.id
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • portfolioId — VARCHAR(191) — Foreign key → portfolios.id
  • INDEX — `skills_roleId_fkey`
  • INDEX — `skills_profileId_fkey`
  • INDEX — `skills_portfolioId_fkey`

social_links

  • id — INT — Primary key — NOT NULL
  • platform — ENUM('YOUTUBE', 'FACEBOOK', 'INSTAGRAM', 'KAKAOTALK') — NOT NULL
  • url — VARCHAR(191) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `social_links_userId_fkey`

tags

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userDetailId — INT — Foreign key → user_details.id
  • magazineId — INT — Foreign key → magazines.id
  • communityId — INT — Foreign key → communities.id
  • INDEX — `tags_userDetailId_fkey`
  • INDEX — `tags_magazineId_fkey`
  • INDEX — `tags_communityId_fkey`

terms

  • id — INT — Primary key — NOT NULL
  • content — LONGTEXT — NOT NULL
  • type — VARCHAR(191) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

upload_logs

  • id — INT — Primary key — NOT NULL
  • nid — VARCHAR(255) — NOT NULL
  • ip — VARCHAR(255) — NOT NULL
  • os — VARCHAR(255)
  • browser — VARCHAR(255)
  • size — INT
  • downcnt — INT
  • userId — INT — Foreign key → users.id
  • fname — VARCHAR(255)
  • url — VARCHAR(1000)
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • INDEX — `upload_logs_userId_fkey`

urls

  • id — INT — Primary key — NOT NULL
  • url — LONGTEXT — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id
  • companyId — INT — Foreign key → companies.id
  • castingCallId — VARCHAR(191) — Foreign key → casting_calls.id
  • profileId — VARCHAR(191) — Foreign key → profiles.id
  • portfolioId — VARCHAR(191) — Foreign key → portfolios.id
  • INDEX — `urls_userId_fkey`
  • INDEX — `urls_companyId_fkey`
  • INDEX — `urls_castingCallId_fkey`
  • INDEX — `urls_profileId_fkey`
  • INDEX — `urls_portfolioId_fkey`

user_details

  • id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(191) — NOT NULL
  • introduction — LONGTEXT
  • personalHistory — VARCHAR(191)
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL

user_login_history

  • id — INT — Primary key — NOT NULL
  • ip — VARCHAR(100)
  • os — VARCHAR(100)
  • browser — VARCHAR(100)
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • INDEX — `user_login_history_userId_fkey`

users

  • id — INT — Primary key — NOT NULL
  • uniqueId — VARCHAR(191) — NOT NULL
  • email — VARCHAR(191) — NOT NULL
  • name — VARCHAR(191) — NOT NULL
  • activityName — VARCHAR(191) — NOT NULL
  • password — VARCHAR(191)
  • birthday — VARCHAR(191)
  • phone — VARCHAR(191) — NOT NULL
  • grade — INT — NOT NULL
  • votesToday — INT — NOT NULL
  • lastVotedDate — DATETIME(3) — NOT NULL
  • role — ENUM('USER', 'BUSINESS', 'ADMIN') — NOT NULL
  • status — ENUM('RUN', 'WAIT', 'STOP') — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • updatedAt — DATETIME(3) — NOT NULL

votes

  • id — INT — Primary key — NOT NULL
  • vote — TINYINT(1) — NOT NULL
  • createdAt — DATETIME(3) — NOT NULL
  • userId — INT — Foreign key → users.id — NOT NULL
  • profileId — VARCHAR(191) — Foreign key → profiles.id — NOT NULL
  • INDEX — `votes_profileId_fkey`