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)