orgTalk

Tables (6)

chat_messages

  • id — VARCHAR(24) — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • sender_name — VARCHAR(255) — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • message — TEXT
  • code_content — TEXT
  • language — VARCHAR(50)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_room

  • id — BIGINT — Primary key — NOT NULL
  • organization_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • type — VARCHAR(50) — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • password — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_room_member

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
  • member_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • github_id — BIGINT
  • login — VARCHAR(255)
  • email — VARCHAR(255)
  • avatar_url — VARCHAR(255)
  • member_role — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

member_organizations

  • organization_id (organizations_id) — BIGINT — Foreign key → member.id — NOT NULL
  • member_id — BIGINT — Foreign key → organization.id — NOT NULL

organization

  • id — BIGINT — Primary key — NOT NULL
  • login — VARCHAR(255) — NOT NULL
  • avatar_url — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME