CONX ERD_final
Tables (11)
Evaluation (Untitled2)
- id — BIGINT — Primary key — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key → crew.id — NOT NULL
- mean — FLOAT
- completeness — FLOAT
- schedule — FLOAT
- ability — FLOAT
- recooperation — FLOAT
- communication — FLOAT
Portfolio (Untitled)
- id — BIGINT — Primary key — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key → crew.id — NOT NULL
- portfolio_image (portfolioImage) — VARCHAR(500)
- portfolio_name (portfolioName) — VARCHAR(255)
- project_type (projectType) — VARCHAR(255)
- platform — VARCHAR(255)
- description — VARCHAR(500)
company
- id — BIGINT — Primary key — NOT NULL
- company_name (companyName) — VARCHAR(100)
- company_intoduction (companyIntroduction) — VARCHAR(255)
- brand_name (brandName) — VARCHAR(255) — NOT NULL
- industry — ENUM
- custom_industry (customIndustry) — VARCHAR(100)
- manager_name (managerName) — VARCHAR(100)
- job — VARCHAR(100)
- business_registration_number (businessRegistrationNumber) — VARCHAR(100)
- profile_image (profileImage) — VARCHAR(500)
- additional_file_link (additionalFileLink) — VARCHAR(500)
- homepage_link (homepageLink) — VARCHAR(255)
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — ENUM
- status — ENUM
crew
- id — BIGINT — Primary key — NOT NULL
- crew_name (crewName) — VARCHAR(255) — NOT NULL
- crew_type (crewType) — VARCHAR(100)
- custom_crew_type (customCrewType) — VARCHAR(100)
- manager_name (managerName) — VARCHAR(100)
- job — VARCHAR(100)
- profile_image (profileImage) — VARCHAR(500)
- crew_school (crewSchool) — VARCHAR(100)
- member_amount (memberAmount) — INT
- interesting_industry (interestingIndustry) — VARCHAR(255)
- channel — VARCHAR(255)
- crew_introduction (crewIntroduction) — VARCHAR(255)
- advantages — VARCHAR(500) — String[]
- sns_link (snsLink) — VARCHAR(255)
- etc_link (etcLink) — VARCHAR(255)
- kakaotalk_link (kakaotalkLink) — VARCHAR(255)
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — ENUM
- status — ENUM
crew_bookmark
- id — BIGINT — Primary key — NOT NULL
- company_id (companyId) — BIGINT — Foreign key — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
file
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → company.id — NOT NULL
- crew_id — BIGINT — Foreign key → crew.id — NOT NULL
- original_name (originalName) — VARCHAR(255) — NOT NULL
- stored_name (storedName) — VARCHAR(255) — NOT NULL
- file_url (fileUrl) — VARCHAR(500) — NOT NULL
- content_type (contentType) — VARCHAR(100)
- file_size (fileSize) — BIGINT
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
personal_information_consent
- id — BIGINT — Primary key — NOT NULL
- company_id (companyId) — BIGINT — Foreign key → company.id — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key → crew.id — NOT NULL
- is_allowed (isAllowed) — BOOLEAN — NOT NULL
- consented_at (consentedAt) — DATETIME
- created_at (createdAt) — DATETIME
- updated_at (updatedAt) — DATETIME
- deleted_at (deletedAt) — DATETIME
project
- id — BIGINT — Primary key — NOT NULL
- company_id (company) — BIGINT — Foreign key — NOT NULL
- selected_crew_id (selectedCrew) — BIGINT — Foreign key → crew.id — NOT NULL
- manager_name (managerName) — VARCHAR(255)
- manager_email (managerEmail) — VARCHAR(255)
- manager_phone (managerPhone) — VARCHAR(255)
- project_image (projectImage) — VARCHAR(500)
- brand_name (brandName) — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- objectives — VARCHAR(500)
- project_type (projectType) — ENUM
- requirement — ENUM
- project_explanation (projectExplanation) — TEXT
- result_form (resultForm) — VARCHAR(500)
- essential_submit_part (essentialSubmitPart) — VARCHAR(500)
- recruit_deadline (recruitDeadline) — DATE
- project_start_date (projectStartDate) — DATE
- project_deadline (projectDeadline) — DATE
- submit_deadline (submitDeadline) — DATE
- crew_type (crewType) — ENUM
- competency — ENUM
- preference_condition (preferenceCondition) — VARCHAR(500)
- subsidy — BIGINT
- incentive — BOOLEAN
- incentive_condition — VARCHAR(500)
- reference_link (referenceLink) — VARCHAR(255)
- status — ENUM — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
project_application
- id — BIGINT — Primary key — NOT NULL
- project_id (projectId) — BIGINT — Foreign key — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key — NOT NULL
- status — VARCHAR(50) — NOT NULL
- application_message (applicationMessage) — TEXT
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
project_bookmark
- id — BIGINT — Primary key — NOT NULL
- project_id (projectId) — BIGINT — Foreign key — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- deleted_at (deletedAt) — DATETIME
promotional_message_consent
- id — BIGINT — Primary key — NOT NULL
- company_id (companyId) — BIGINT — Foreign key → company.id — NOT NULL
- crew_id (crewId) — BIGINT — Foreign key → crew.id — NOT NULL
- is_allowed (isAllowed) — BOOLEAN — NOT NULL
- consented_at (consentedAt) — DATETIME
- created_at (createdAt) — DATETIME
- updated_at (updatedAt) — DATETIME
- deleted_at (deletedAt) — DATETIME