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