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