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