mangho
Tables (6)
CHANNEL (Untitled2)
- ID (Key) — BIGINT — Primary key — NOT NULL
- TYPE (Field2) — TINYINT — NOT NULL
- CREATED_AT (Field3) — DATETIME — NOT NULL
- IS_DELETED (Field4) — TINYINT(1) — NOT NULL
CONNECTING_STATUS_LOG (Untitled4)
- ID (Key) — BIGINT — Primary key — NOT NULL
- MEMBER_ID (Key2) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
- STATUS (Field) — TINYINT — NOT NULL
- CHANGED_AT (Field2) — DATETIME — NOT NULL
MEMBER
- ID (Key) — BIGINT — Primary key — NOT NULL
- NICKNAME (Field) — VARCHAR(20) — NOT NULL
- PASSWORD (Field2) — VARCHAR(255) — NOT NULL
- CREATED_AT (Field3) — DATETIME
- UPDATED_AT (Field4) — DATETIME
- IS_DELETED (Field5) — TINYINT(1) — NOT NULL
MESSAGE (Untitled)
- ID (Key) — BIGINT — Primary key — NOT NULL
- CHANNEL_ID (Key3) — BIGINT — Foreign key → CHANNEL.ID — NOT NULL
- SENDER_ID (Key2) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
- CONTENT (Field) — MEDIUMTEXT — NOT NULL — <= 10만 자
- CREATED_AT (Field2) — DATETIME — NOT NULL
- IS_DELETED (Field4) — TINYINT — NOT NULL
TEAM
- ID (Key) — BIGINT — Primary key — NOT NULL
- TITLE (Field) — VARCHAR(255)
- LEADER_ID (Field2) — BIGINT
- CREATED_AT (Field3) — DATETIME — NOT NULL
- UPDATED_AT (Field4) — DATETIME — NOT NULL
- IS_DELETED (Field5) — TINYINT(1) — NOT NULL
TEAM_PARTICIPATION (Untitled3)
- TEAM_ID (Key3) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
- MEMBER_ID (Key4) — BIGINT — Foreign key → TEAM.ID — NOT NULL
- IS_APPROVED (Field) — TINYINT(1) — NOT NULL
- CREATED_AT (Field2) — DATETIME — NOT NULL
- UPDATED_AT (Field3) — DATETIME — NOT NULL
- IS_DELETED (Field4) — TINYINT(1) — NOT NULL