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