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