maeum canvas
Tables (10)
Board (게시글)
- boardId (PK) — Int — Primary key — NOT NULL
- uid (FK) — Int — Foreign key → User.uid — NOT NULL
- category (FK2) — Char — Foreign key → Category.category — NOT NULL
- title (Field) — Char
- boardContent (Field2) — Varchar
- boardWriteTime (Field3) — DateTime
- Secret (Field4) — Boolean
Category (게시글 분류)
- category (PK) — Char — Primary key — NOT NULL
Comment (댓글)
- id (PK) — Int — Primary key — NOT NULL
- boardId (FK) — Int — Foreign key → Board.boardId — NOT NULL
- uid (FK2) — Int
- Comment (Field) — Varchar
- commentWriteTime (Field2) — DateTime
Counseling (상담)
- counselingId (PK) — Int — Primary key — NOT NULL
- counselorId (FK) — Int — Foreign key → User.uid — NOT NULL
- studentId (FK2) — Int
- counselingTime (Field) — Datetime
CounselingResult (상담 결과)
- counselingId (PK/FK) — Int — Foreign key → Counseling.counselingId — NOT NULL
- counselingResult (Field) — Varchar
Drawing (그림)
- drawingId (PK) — Int — Primary key — NOT NULL
- uid (FK) — Int — Foreign key → User.uid — NOT NULL
- drawing (Field2) — Varchar
- drawingTime (Field) — Datetime
DrawingResult (그림 분석 결과)
- drawingId (PK/FK) — Int — Foreign key → Drawing.drawingId — NOT NULL
- drawingResult (Field) — Varchar
School (소속학교)
- schoolName (PK) — Char — Primary key — NOT NULL
SurveyResult (설문 결과)
- surveyId (PK) — Int — Primary key — NOT NULL
- uid (FK) — Int — Foreign key → User.uid — NOT NULL
- score (Field) — Int
- surveyTime (Field2) — Datetime
- surveyCategory (Field3) — Char
User (사용자)
- uid (PK) — Int — Primary key — NOT NULL
- schoolName (FK) — Char — Foreign key → School.schoolName — NOT NULL
- email (Field6) — Varchar
- name (Field) — Char
- phoneNumber (Field2) — Int
- password (Field3) — Char
- nickname (Field4) — Char
- role (Field5) — Enum