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