CalendarV2

Tables (3)

Event (EVENT)

  • Key (EVENT_ID) — BIGINT — Primary key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → USER.Key — NOT NULL
  • Field (TITLE) — VARCHAR(255)
  • Field (CONTEXTS) — TEXT
  • Field (CREATED_AT) — DATETIME — NOT NULL
  • Field (UPDATED_AT) — DATETIME — NOT NULL

USER

  • Key (USER_ID) — BIGINT — Primary key — NOT NULL
  • Key (NAME) — VARCHAR(10) — NOT NULL
  • Field (EMAIL) — VARCHAR(40) — NOT NULL
  • Field (PASSWORD) — VARCHAR(255) — NOT NULL
  • Field (CREATED_AT) — DATETIME — NOT NULL
  • Field (UPDATED_AT) — DATETIME — NOT NULL

Untitled (COMMENT)

  • Key (COMMENT_ID) — BIGINT — Primary key — NOT NULL
  • Key (EVENT_ID) — BIGINT — Foreign key → Event.Key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → USER.Key — NOT NULL
  • Field (COMMENT) — TEXT
  • Key (CREATED_AT) — DATETIME — NOT NULL
  • Field (UPDATED_AT) — DATETIME — NOT NULL