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