FriendJect

Tables (13)

Counseling Room (counseling_room)

  • No (no) — AI — Primary key — NOT NULL
  • Id (id) — INT — Foreign key → Room.Id — NOT NULL
  • Start time (start_time) — DATETIME
  • End Time (end_time) — DATETIME
  • Problem (problem) — VARCHAR(100)
  • Solution (solution) — VARCHAR(100)
  • Counselor Id (counselor_id) — INT
  • Counselee ID (counselee_id) — INT

Document (회의록)

  • Id (id) — INT — Primary key — NOT NULL
  • Room Id (room_id) — INT — Foreign key → Meeting Room.Id — NOT NULL
  • Content (content) — TEXT
  • Title (title) — VARCHAR(200)
  • Meeting Time (meeting_time) — DATETIME

Drive (drive)

  • FileId (file_id) — VARCHAR(100) — Primary key — NOT NULL
  • FileName (file_name) — VARCHAR(100)
  • FileOriginName (file_origin_name) — VARCHAR(100)
  • FilePath (file_path) — TEXT
  • ContentType (content_type) — VARCHAR(50)
  • ProjectId (project_id) — INT — Foreign key → Project Room.Id — NOT NULL

Meeting Room (meeting_room)

  • Id (id) — INT — Foreign key → Room.Id — NOT NULL

Memo Board (memo_board)

  • Id (id) — INT — Primary key — NOT NULL
  • Room Id (room_id) — INT — Foreign key → Project Room.Id — NOT NULL
  • Title (title) — VARCHAR(50)
  • Content (content) — TEXT
  • Nickname (nickname) — VARCHAR(20) — NOT NULL
  • Write Time (write_time) — DATETIME — NOT NULL

Project Room (project_room)

  • Id (id) — INT — Foreign key → Room.Id — NOT NULL
  • Field

Room (room)

  • Id (id) — INT — Primary key — NOT NULL
  • Room Category (room_category) — CHAR(1)
  • Start Time (start_time) — DATETIME — NOT NULL
  • End Time (end_time) — DATETIME — NOT NULL
  • is Active (is_active) — BOOLEAN — NOT NULL

Room History (room_history)

  • Id (id) — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.Id — NOT NULL
  • Room id (room_id) — INT — Foreign key → Room.Id — NOT NULL
  • Inserted Time (inserted_time) — DATETIME — NOT NULL
  • Action (action) — SMALLINT — NOT NULL — create, join, exit

Study Room (study_room)

  • Id (id) — INT — Foreign key → Room.Id — NOT NULL

Team (team)

  • Team id (team_id) — CHAR(6) — Primary key — NOT NULL — 팀번호
  • Name (name) — VARCHAR(20) — NOT NULL

Tool Site (tool_site)

  • Room Id (room_id) — INT — Foreign key → Project Room.Id — NOT NULL
  • Google Drive URL (google_drive_url) — TEXT

URL (url)

  • Room Id (room_id) — INT — Foreign key → Tool Site.Room Id — NOT NULL
  • Name (name) — VARCHAR(30)
  • URL (url) — TEXT

User (user)

  • Id (id) — INT — Primary key — NOT NULL
  • Team id (team_id) — CHAR(6) — Foreign key → Team.Team id — NOT NULL — 팀번호
  • Name (name) — VARCHAR(20) — NOT NULL
  • Nickname (nickname) — VARCHAR(20) — NOT NULL
  • Password (password) — VARCHAR(20) — NOT NULL
  • Profile (profile) — TEXT
  • Auth (auth) — CHAR(1) — NOT NULL — 관리자 : 'S' 사용자 : 'U'(default)
  • Minimi (minimi) — INT