Impactive AI ERD
Tables (10)
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
General (general)
- Project_Id (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL
- Innovativeness (innovativeness) — String
- Usage — 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
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
- MethodType (method_type) — 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
Tag (tag)
- Tag_Id (tag_id) — Long — Primary key — NOT NULL
- Project_Id (project_id) — Long — Foreign key → Project.Project_Id — NOT NULL
- Name (name) — String
User (user)
- User_ID (user_id) — Long — Primary key — NOT NULL
- Name (name) — String
- Email (email) — String
- Reg_Date (reg_date) — Date
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