heyKakao

Tables (10)

Entity (user)

  • PK (id) — Long — Primary key — NOT NULL
  • (account) — String
  • (name) — String
  • (email) — String
  • (age) — Long

Entity (survey)

  • PK (id) — Long — Primary key — NOT NULL
  • (title) — String
  • (state) — Integer
  • (url) — String
  • PK (id2) — Long — Foreign key → Entity.PK — NOT NULL

Entity (question)

  • PK (id) — Long — Primary key — NOT NULL
  • (type) — Integer
  • (order) — Integer
  • (contents) — String

Entity (answer)

  • PK (id) — Long — Primary key — NOT NULL
  • (order) — Integer
  • (contents) — String

Entity (choice)

  • PK (id) — Long — Primary key — NOT NULL
  • (order) — Integer
  • (contents) — String
  • (question) — String

Table (User)

  • PK (id) — Long — Primary key — NOT NULL
  • (account) — String
  • (name) — String
  • (email) — String
  • (age) — Long

Table (Survey)

  • PK (id) — Long — Primary key — NOT NULL
  • PK (user_id) — Long — Foreign key → Table.PK — NOT NULL
  • (title) — String
  • (state) — Integer
  • (url) — String

Table (Question)

  • PK (id) — Long — Primary key — NOT NULL
  • PK (survey_id) — Long — Foreign key → Table.PK — NOT NULL
  • (type) — Integer
  • (order) — Integer
  • (contents) — String

Table (Choice)

  • PK (id) — Long — Primary key — NOT NULL
  • PK (question_id) — Long — Foreign key → Table.PK — NOT NULL
  • (order) — Integer
  • (contents) — String
  • (question) — String

Table (Answer)

  • PK (id) — Long — Primary key — NOT NULL
  • PK (question_id) — Long — Foreign key → Table.PK — NOT NULL
  • PK (user_id) — Long — Foreign key → Table.PK — NOT NULL
  • (order) — Integer
  • (contents) — String