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`