gistfile1.txt

User
-
id PK int
name string
email string UNIQUE
phone_number string NULLABLE

Customer
-
id PK int
name string UNIQUE


Role
-
id PK int
customer_id PK int
name string
customer_id_actual FK >- Customer.id

Permission
-
id PK int
name string UNIQUE

RolePermission
-
role_id int FK >- Role.id
permission_id int FK >- Permission.id


UserRole
-
user_id int FK >- User.id
role_id int FK >- Role.id
customer_id FK >- Customer.id


CustomerGroup
-
customer_id int FK >- Customer.id
group_id int FK >- Group.id

Group
-
id PK int
name string
description string

InstructorGroup
-
user_id int FK >- User.id
group_id int FK >- Group.id

UserGroup
-
user_id int FK >- User.id
group_id int FK >- Group.id

Announcement
-
id PK int
poster_user_id int FK >- User.id
group_id int FK >- Group.id
content text
posted_date_time datetime

Event
-
id PK int
creator_user_id int FK >- User.id
group_id int FK >- Group.id
name string
description text
event_date_time datetime