OrgTalk

Tables (5)

ChatRoom

  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Member

  • id — BIGINT — Primary key
  • github_id — BIGINT — NOT NULL
  • github_login — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • avatar_url — VARCHAR(500)
  • access_token — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

MemberOrganization

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • organization_id — BIGINT — NOT NULL
  • role — VARCHAR(100)
  • joined_at — TIMESTAMP

Message

  • id — BIGINT
  • chatroom_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Organization

  • id — BIGINT
  • github_org_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • avatar_url — VARCHAR(500)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP