Orange-Compass
Tables (6)
Chat
- Key (id) — bigInt(20) — Primary key — NOT NULL
- Key (chat_room_id) — bigInt(20) — Foreign key → ChatRoom.Key — NOT NULL
- Field (contents) — varchar(255)
- Field (role) — varchar(255)
- Field (created_at) — datetime
- Field (sequence) — int
ChatRoom
- Key (id) — bigInt(20) — Primary key — NOT NULL
- Key (subject_id) — bigInt(20) — Foreign key → Subject.Key — NOT NULL
- Key (lastchat_id) — bigInt(20) — Foreign key → Chat.Key — NOT NULL
- Field (created_at) — datetime
- Field (updated_at) — datetime
Folder
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (user_id) — bigint(20) — Foreign key → User.Key — NOT NULL — Auto Increment
- Field2 (name) — varchar(255)
- Field3 (color) — varchar(255)
Subject
- Key (id) — bigInt(20) — Primary key — NOT NULL
- Key (folder_id) — bigint(20) — Foreign key → Folder.Key — NOT NULL
- Field (name) — varchar(255)
- Field (level) — varchar(255)
User
- Key (id) — bigint(20) — Primary key — NOT NULL — Auto Increment
- Field (username) — varchar(15)
- Field2 (email) — varchar(255)
- Field3 (password) — varchar(255)
- Field (birth) — date
- Field4 (type) — varchar(255)
- Field (login_type) — varchar(255)
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
- Field (status) — varchar(255)
- Field (profile_img_url) — varchar(255)
note (Note)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (subject_id) — bigint(20) — Foreign key → Subject.Key — NOT NULL
- Field (note_url) — varchar(255)