d

Tables (3)

CARD (card)

  • ID (id) — Long — Primary key — NOT NULL
  • Date (date) — timestamptz
  • Email (emaile) — Text
  • NickName (nickname) — Text
  • Title (title) — Text
  • Status (status) — Text
  • Contents (contents) — Text
  • UserId (userid) — Long — Foreign key → USER.ID — NOT NULL

Comment (comment)

  • ID (id) — Long — Primary key — NOT NULL
  • Date (date) — timestamptz
  • Email (emaile) — Text
  • NickName (nickname) — Text
  • Title (title) — Text
  • Status (status) — Text
  • Contents (contents) — Text
  • UserId (userId) — Long — Foreign key → CARD.ID — NOT NULL
  • CardId (cardId) — Long — Foreign key → USER.ID — NOT NULL

USER (user)

  • ID (id) — Long — Primary key — NOT NULL
  • Created At (created_at) — timestamptz
  • Password (password) — Text
  • NickName (nickname) — Text
  • Role (role) — Text
  • Email (email) — Text — NOT NULL