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