moment

Tables (6)

COMMENT (Untitled2)

  • ID (Key3) — BIGINT — Primary key — NOT NULL
  • COMMENTER_ID (Key) — BIGINT — Foreign key → USER.ID — NOT NULL
  • MOMENT_ID (Key2) — BIGINT — Foreign key → MOMENT.ID — NOT NULL
  • CREATED_AT (Field) — TIMESTAMP
  • CONTENT (Field2) — VARCHAR(255)

EMOJI (Untitled3)

  • ID (Key2) — BIGINT — Primary key — NOT NULL
  • USER_ID (Key) — BIGINT — Foreign key → USER.ID — NOT NULL
  • COMMENT_ID (Key3) — BIGINT — Foreign key → COMMENT.ID — NOT NULL
  • TYPE (Field) — VARCHAR(255)
  • CREATED_AT (Field2) — TIMESTAMP

MATCHING (Untitled4)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • MOMENT_ID (Key2) — BIGINT — Foreign key → MOMENT.ID — NOT NULL
  • COMMETER_ID (Key3) — BIGINT — Foreign key → USER.ID — NOT NULL
  • CREATED_AT (Field) — TIMESTAMP

MOMENT (Untitled)

  • ID (Key2) — BIGINT — Primary key — NOT NULL
  • MOMENTER_ID (Key) — BIGINT — Foreign key → USER.ID — NOT NULL
  • CREATED_AT (Field) — TIMESTAMP
  • CONTENT (Field2) — VARCHAR(255)
  • IS_MATCHED (Field3) — BOOLEAN

POINT_HISTORY (Untitled5)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (Key2) — BIGINT — Foreign key → USER.ID — NOT NULL
  • AMOUNT (Field) — INT
  • REASON (Field2) — VARCHAR(255)
  • CREATED_AT (Field3) — TIMESTAMP
  • CONTENT_ID (Field4) — BIGINT

USER

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • CREATED_AT (Field4) — TIMESTAMP
  • EMAIL (Field) — VARCHAR(255)
  • PASSWORD (Field2) — VARCHAR(255)
  • NICK_NAME (Field3) — VARCHAR(255)
  • CURRENT_POINT (Field5) — INT
  • LEVEL (Field6) — VARCHAR(255)