GuGu
Tables (9)
category
- id (Key) — bigint(20) — Primary key — NOT NULL
- category_name (Field) — varchar(15) — NOT NULL
- is_private (Field1) — tinyint(1) — NOT NULL
- server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL
category_member (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (PK) — bigint(20) — Foreign key → user.id — NOT NULL
- category_id (Key2) — bigint(20) — Foreign key → category.id — NOT NULL
- role_id (Key3) — bigint(20) — Foreign key → role.id — NOT NULL
channel
- id (Key) — bigint(20) — Primary key — NOT NULL
- channel_name (Field) — varhchar(15) — NOT NULL
- channel_type (Field1) — varchar(1) — NOT NULL
- is_private (Field2) — tynyint(1) — NOT NULL
- description (Field3) — varchar(1024)
- server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL
- category_id (Key3) — bigint(20) — Foreign key → category.id — NOT NULL
channel_member (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (PK) — bigint(20) — Foreign key → user.id — NOT NULL
- channel_id (Key2) — bigint(20) — Foreign key → channel.id — NOT NULL
permission (authorization)
- id (Key) — bigint(20) — Primary key — NOT NULL
- permission1 (Field) — tinyint(1)
- permission2 (Field2) — tinyint(1)
- permission3 (Field3) — tinyint(1)
- permission4 (Field4) — tinyint(1)
- permission5 (Field5) — tinyint(1)
role
- id (Key) — bigint(20) — Primary key — NOT NULL
- role_name (Field) — varchar(15) — NOT NULL
- color (Field2) — int(6) — NOT NULL
- permission_id (Key2) — bigint(20) — Foreign key → permission.id — NOT NULL
server
- id (Key) — bigint(20) — Primary key — NOT NULL
- server_name (Field) — varchar(15) — NOT NULL
- image (Field1) — varchar(255)
server_member (Untitled)
- id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (PK) — int(10) — Foreign key → user.id — NOT NULL
- server_id (Key2) — bigint(20) — Foreign key → server.id — NOT NULL
- role_id (Key3) — bigint(20) — Foreign key → role.id — NOT NULL
- profile_image (Field) — text — NOT NULL
- nick_name (Field3) — varchar(10) — NOT NULL
user (users)
- id (PK) — bigint(20) — Primary key — NOT NULL
- email (Field1) — varchar(50) — NOT NULL
- e_password (Field2) — varchar(50) — NOT NULL
- username (Field3) — varchar(10) — NOT NULL
- birth (Field9) — datetime
- image (Field4) — varchar(255)
- banner_color (Field7) — varchar(10)
- message (Field8) — varchar(10)
- refresh_token (Field5) — varchar(60)