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)