erdrd

Tables (10)

USER (User)

  • 사용자식별코드(PK) (uid) — string — Primary key — NOT NULL
  • 카카오 구글 (provider) — string — NOT NULL
  • 이메일(unique) (email) — string — NOT NULL — 유니크
  • 닉네임 (nickname) — string — NOT NULL
  • Field (weekly_count) — int
  • Field (ticket) — int

Untitled (Report)

  • Key (report_idx) — int — Primary key — NOT NULL
  • 사용자식별코드(PK) (uid) — string — Foreign key → USER.사용자식별코드(PK) — NOT NULL
  • Key (card_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (question_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (datetime) — string
  • Field (ment) — string

Untitled (Card)

  • Key (idx) — int — Primary key — NOT NULL
  • Field (name) — string

Untitled (LuckyCard)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (card_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (luckyment) — string

Untitled (TimeCard)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (card_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (timement) — string

Untitled (InstantCard)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (card_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (question) — string
  • Field (advice) — string

Untitled (ReportQuestion)

  • Key (idx) — int — Primary key — NOT NULL
  • 사용자식별코드(PK) (uid) — string — Foreign key → USER.사용자식별코드(PK) — NOT NULL
  • Field (options) — string
  • Field (summary) — string
  • Field (question) — string

Untitled (RandomNickname)

  • Key (idx) — int — Primary key — NOT NULL
  • Field (name) — string

Untitled (Quiz)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (card_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — string
  • Field (answer) — string
  • Field (wrong1) — string
  • Field (wrong2) — string
  • Field (wrong3) — string

Untitled (QuizList)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (quiz_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (localDateTime) — datetime