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