AI ERD-Final

Tables (23)

Age (age)

  • Age_ID (age_id) — Long — Primary key — NOT NULL
  • Range (range) — String

Chart (chart)

  • Chart_Id (chartId) — Long — Primary key — NOT NULL
  • Name (name) — String

Detail_Idea (detail_idea)

  • Key (report_id) — Long — Primary key — NOT NULL
  • Idea_id — Long — Foreign key → Idea.Idea_id — NOT NULL
  • Project ID (project_id) — Long — Foreign key → Idea.Project ID — NOT NULL
  • Innovativeness (innovativeness) — String
  • Marketability (marketability) — String
  • Value Creation (valueCreation) — String
  • Consumer Acceptance (consumerAcceptance) — String
  • Cost Aspect (costAspect) — String
  • Feasibility (feasibility) — String
  • Negative Aspect (negativeAspect) — String
  • Image url (image_url) — String
  • Is_Liked (is_liked) — Boolean
  • Created_At (created_at) — Date

Function (function)

  • Function_ID (function_id) — Long — Primary key — NOT NULL
  • Kano_ID (kano_id) — Long — Foreign key → Kano.Kano_ID — NOT NULL
  • Name (name) — String
  • Description (description) — String
  • PlanVersion (planVersion) — String

Gender (enum_g)

  • Male (male) — String
  • Female (female) — String

General (general)

  • Project_Id (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL
  • Innovativeness (innovativeness) — String
  • Purpose (purpose) — String
  • Directionality (directionality) — String

Idea (idea)

  • Idea_id — Long — Primary key — NOT NULL
  • Project ID (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL
  • Title (title) — String
  • Description (description) — String
  • method_Type (method_type) — String

Item (item)

  • Item_ID (item_id) — Long — Primary key — NOT NULL
  • Name (name) — String

Job (job)

  • Job_ID (job_id) — Long — Primary key — NOT NULL
  • Kano_ID (kano_id) — Long — Foreign key → Kano.Kano_ID — NOT NULL
  • Name (name) — String

Kano (kano)

  • Kano_ID (kano_id) — Long — Primary key — NOT NULL
  • User_ID (user_id) — Long — Foreign key → User.User_ID — NOT NULL
  • Model_Name (modelName) — String
  • LastUsedDate (last_used_date) — Date
  • PlanVersion (plan_version) — String
  • prevVersionList_ID (prev_version_id) — Long
  • Gender (gender) — Gender
  • Created_At (created_at) — Date
  • Updated_At (updated_at) — Date
  • isLiked (is_liked) — boolean

KanoAge (kanoAge)

  • kanoAge_ID (kanoAge_id) — Long — Primary key — NOT NULL
  • Age_ID (age_id) — Long — Foreign key → Age.Age_ID — NOT NULL
  • Kano_ID (kano_id) — Long — Foreign key → Kano.Kano_ID — NOT NULL
  • report_id (reportId) — Long — Foreign key → KanoReport.report_id — NOT NULL
  • Kano_ID (kano_id2) — Long — Foreign key → KanoReport.Kano_ID — NOT NULL
  • User_ID (user_id) — Long — Foreign key → KanoReport.User_ID — NOT NULL

KanoData (kanodata)

  • CS_ID (cs_id) — Long — Primary key — NOT NULL
  • coeffienct (satisfaction) — Double
  • Name (name) — String

KanoReport (kanoReport)

  • report_id (reportId) — Long — Primary key — NOT NULL
  • Kano_ID (kano_id) — Long — Foreign key → Kano.Kano_ID — NOT NULL
  • User_ID (user_id) — Long — Foreign key → Kano.User_ID — NOT NULL
  • name (Field2) — String
  • PlanVersion (Field3) — String
  • prevVersionList (Field) — List
  • Created_At (Field4) — Date
  • Updated_At (Field5) — Date
  • isLiked (Field6) — boolean
  • LastUsedDate (Field7) — Date

Keyword (keyword)

  • Keyword_ID (keyword_id) — Long — Primary key — NOT NULL
  • Title (title) — String
  • Category (category) — KeywordCategory

KeywordCategory (enum)

  • RANDOM_CARD (랜덤카드)
  • VALUE_CREATION_WHO (가치창출WHO)
  • VALUE_CREATION_HOW (가치창출HOW)
  • VALUE_CREATION_VALUE (가치창출VALUE)

PrevVersion (prevVersion)

  • prevVersion_ID (prevVersion_Id) — Long — Primary key — NOT NULL
  • Kano_ID (kano_id) — Long — Foreign key → Kano.Kano_ID — NOT NULL
  • Function_ID (function_id) — Long — Foreign key → Function.Function_ID — NOT NULL
  • Name (name) — String

Project (project)

  • Project_Id (project_id) — Long — Primary key — NOT NULL
  • User_Id (user_id) — Long — Foreign key → User.User_ID — NOT NULL
  • Search_Word (search_word) — String
  • Title (title) — String
  • Created_At (created_at) — Date
  • Updated_At (updated_at) — Date
  • Is_Liked (is_liked) — boolean

Random_Word (random_word)

  • Project_Id (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL

SearchHistory (searchHistory)

  • User_ID (user_id) — Long — Foreign key → User.User_ID — NOT NULL
  • Search_Id (search_id) — Long
  • SearchTerm (searchTerm) — String
  • Count (count) — Integer
  • Created_At (created_at) — Date
  • Updated_At (updated_at) — Date

User (user)

  • User_ID (user_id) — Long — Primary key — NOT NULL
  • Name (name) — String
  • Email (email) — String
  • Created_At (created_at) — Date
  • Updated_At (updated_at) — Date
  • UID (uid) — String

UserKeyword (userKeyword)

  • UserKeyword_ID (user_keyword_id) — Long — Primary key — NOT NULL
  • Keyword_ID (keyword_id2) — Long — Foreign key → Keyword.Keyword_ID — NOT NULL
  • User_ID (user_id) — Long — Foreign key → User.User_ID — NOT NULL

Value (value)

  • Project_Id (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL
  • Target (target) — String
  • Strategy (strategy) — String
  • Result (result) — String

Word (word)

  • Word_Id (word_id) — Long — Primary key — NOT NULL
  • Project_Id (project_id) — Long — Foreign key → Random_Word.Project_Id — NOT NULL
  • Name (name) — String