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)