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