sg
Tables (5)
Artwork
- artworkID — BINARY(16) — Primary key — NOT NULL
- ID — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- ID2 — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- emotionID — BINARY(16) — Foreign key → Emotion.emotionID — NOT NULL
- emotionID2 — BINARY(16) — Foreign key → Emotion.emotionID — NOT NULL
- artworkPath — VARCHAR(255) — NOT NULL
- date — DATE — NOT NULL
Emotion
- emotionID — BINARY(16) — Primary key — NOT NULL
- ID — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- qnaID — BINARY(16) — Foreign key → QnA.qnaID — NOT NULL
- qnaID2 — BINARY(16) — Foreign key → QnA.qnaID — NOT NULL
- qnaID3 — BINARY(16) — Foreign key → QnA.qnaID — NOT NULL
- color — VARCHAR(10) — NOT NULL
- date — DATE — NOT NULL
QnA
- qnaID — BINARY(16) — Primary key — NOT NULL
- questionID — BINARY(16) — Foreign key → Question.questionID — NOT NULL
- answerText — VARCHAR(255)
Question
- questionID — BINARY(16) — Primary key — NOT NULL
- questionText — VARCHAR(255) — NOT NULL
User
- ID — VARCHAR(36) — Primary key — NOT NULL
- coupleID — VARCHAR(36) — Foreign key → User.ID
- name — VARCHAR(20)