sgdb
Tables (5)
Artwork
- artworkID — BINARY(16) — Primary key — NOT NULL
- ID1 — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- ID2 — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- emotionID1 — BINARY(16) — Foreign key → Emotion.emotionID — NOT NULL
- emotionID2 — BINARY(16) — Foreign key → Emotion.emotionID — NOT NULL
- artworkPath — VARCHAR(255) — NOT NULL
- date — DATE
Diary
- diaryID — BINARY(16) — Primary key — NOT NULL
- ID — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- questionID1 — BINARY(16) — Foreign key → Question.questionID — NOT NULL
- answerText1 — VARCHAR(255) — NOT NULL
- questionID2 — BINARY(16) — Foreign key → Question.questionID — NOT NULL
- answerText2 — VARCHAR(255) — NOT NULL
- questionID3 — BINARY(16) — Foreign key → Question.questionID — NOT NULL
- answerText3 — VARCHAR(255) — NOT NULL
- date — DATE
Emotion
- emotionID — BINARY(16) — Primary key — NOT NULL
- ID — VARCHAR(36) — Foreign key → User.ID — NOT NULL
- diaryID — BINARY(16) — Foreign key → Diary.diaryID — NOT NULL
- color — VARCHAR(10) — NOT NULL
- date — DATE
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)