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)