hanlight

Tables (33)

Copy Of Copy Of Copy Of Untitled (observer)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (user_pk) — string
  • Field2 (name) — boolean
  • Field (createdAt) — Date
  • Field2 (updatedAt) — Date

Copy Of Copy Of Untitled (mentorRequest)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (team_pk) — number — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (metor_pk) — number — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (content) — string
  • Field2 (done) — boolean
  • Field

Copy Of Untitled (metor)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (user_pk) — string
  • Field (name) — string
  • Field2 (mentorRequest) — MentorRequest[]

Copy Of Untitled2 (team)

  • Key (pk) — number — Primary key — NOT NULL
  • Field2 (name) — string
  • Field (leader_name) — string
  • Field (category) — string — 'l' | 'g'
  • Field2 (code) — number
  • Field3 (createdAt) — Date
  • Field4 (updatedAt) — Date
  • Field5 (teamMember) — TeamMember[]
  • Field6 (mentorRequest) — MentorRequest[]

Copy Of Untitled3 (theme)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (url) — string

Copy Of Untitled4 (teamMember)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (team_pk) — number — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (user_pk) — UUID
  • Field (name) — string
  • Field2 (leader) — boolean
  • Field3 (studentId) — string
  • Field4 (position) — string
  • Field (createdAt) — Date
  • Field2 (updatedAt) — Date

Untitled (staff)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (user_pk) — UUID
  • Field2 (name) — string

Untitled (teamComment)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (team_pk) — number — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (mentor_pk) — number — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (content) — string

Untitled (noticeViewLog)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Key (notice_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (createdAt) — Date

Untitled (judgement)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (url) — string

Untitled (check)

  • Key2 (pk) — number — Primary key — NOT NULL
  • Field (user_pk) — UUID
  • Field2 (type) — string — 'observer' | 'attendee' | 'mentor' | 'staff'
  • Field (name) — string
  • Field3 (here) — boolean

Untitled (timeTableLog)

  • Key (pk) — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name)
  • Field2 (type)
  • Field3 (grade)
  • Field4 (major)
  • Field5 (classNum)
  • Field6 (createdAt)

Untitled (timeTable)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (major) — string
  • Field2 (grade) — number
  • Field3 (classNum) — number
  • Field4 (day) — string
  • Field5 (detail) — string
  • Field6 (th) — number

Untitled (termAcceptLog)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (accept) — boolean
  • Field2 (createdAt) — Date
  • Field3 (updatedAt) — Date

Untitled (teacher)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (name) — string
  • Field2 (createdAt) — Date
  • Field3 (updatedAt) — Date

Untitled (student)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (name) — string
  • Field2 (major) — string — 'H' | 'G' | 'U'
  • Field3 (grade) — string — min: 1, max: 3
  • Field4 (classNum) — number — min: 1, max: 2
  • Field5 (studentNum) — number — min: 1, max: 30
  • Field6 (createdAt) — Date
  • Field7 (updatedAt) — Date

Untitled (parent)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (name) — string
  • Field2 (createdAt) — Date
  • Field3 (updatedAt) — Date

Untitled (board)

  • Key (pk) — number — Primary key — NOT NULL
  • user_pk — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (content) — string
  • Field3 (createdAt) — Date
  • Field (updatedAt) — Date
  • Field2 (comment) — BoardComment[]
  • Field3 (boardLike) — BoardLike[]
  • Field4 (boardImage) — BoardImage[]
  • Field (boardPatchLog) — BoardPatchLog[]
  • Field2 (boardManageLog) — BoardManageLog[]

Untitled (noticeApproveLog)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (notice_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field2 (user_name) — string
  • Field3 (approved) — boolean — 'C' | 'R' | 'U' | 'D'
  • Field4 (type) — string
  • Field5 (title) — string
  • Field6 (content) — string
  • Field7 (createdAt) — Date
  • Field (deletedAt) — Date

Untitled (notice)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (title) — string
  • Field3 (content) — string
  • Field4 (approved) — boolean
  • Field5 (createdAt) — Date
  • Field6 (updatedAt) — Date
  • Field7 (deletedAt) — Date

Untitled (mealOrder)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (order) — string
  • Field2 (count) — number
  • Field3 (createAt) — Date
  • Field4 (updateAt) — Date

Untitled (meal)

  • Key (pk) — number — Primary key — NOT NULL
  • Field (month) — number
  • Field2 (date) — number
  • Field3 (detail) — string

Untitled (graduate)

  • Key (pk) — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (name) — string
  • Field2 (createAt) — Date
  • Field3 (updateAt) — Date

Untitled (calendarLog)

  • Key (pk) — number — Primary key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (type) — string — 'C' | 'U' | 'D'
  • Field2 (year) — number
  • Field3 (month) — number
  • Field4 (date) — number
  • Field5 (detail) — string
  • Field6 (createdAt) — Date
  • Field (updateAt) — Date

Untitled (calendar)

  • Key (pk) — number — Primary key — NOT NULL
  • Field2 (year) — number
  • Field3 (month) — number
  • Field4 (date) — number
  • Field5 (detail) — string
  • Field6 (createdAt) — Date
  • Field (updateAt) — Date

Untitled (boardReportLog)

  • Key (pk) — number — Primary key — NOT NULL
  • Field2 (type) — string — 'board' | 'comment'
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (comment_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — string
  • Field (CreatedAt) — Date

Untitled (boardPatchLog)

  • Key (pk) — number — Primary key — NOT NULL
  • Field2 (type) — string — 'board' | 'comment'
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (comment_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (past_content) — string
  • Field (CreatedAt) — Date

Untitled (boardManageLog)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (type) — string — 'board' | 'comment'
  • Field (reason) — string
  • Field (CreatedAt) — Date

Untitled (boardLike)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (createdAt) — Date

Untitled (boardImage)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (file) — string

Untitled (user)

  • (pk) — UUID — Primary key — NOT NULL
  • Field (type) — string — 'student' | 'teacher' | 'graduate' | 'parent'
  • Field2 (admin) — number — min: 0, max: 7
  • Field3 (id) — string
  • Field4 (password) — string
  • Field5 (passwordKey) — string
  • Field6 (signKey) — string
  • Field (tp) — string
  • Field2 (image) — string
  • Field (createdAt) — Date
  • Field3 (updatedAt) — Date
  • Field (notice) — Notice[]
  • Field2 (board) — Board[]
  • Field3 (boardLike) — BoardLike[]
  • Field4 (boardCommentLike) — BoardCommentLike[]
  • Field5 (noticeViewLog) — NoticeViewLog[]
  • Field6 (calendarLog) — CalendarLog[]
  • Field7 (timeTableLog) — TimeTableLog[]
  • Field8 (boardManageLog) — BoardManageLog[]
  • Field9 (noticeApproveLog) — NoticeApproveLog[]

Untitled (boardCommentLike)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (comment_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (createdAt) — Date

Untitled (boardComment)

  • Key (pk) — number — Primary key — NOT NULL
  • Key (board_pk) — number — Foreign key → Untitled.Key — NOT NULL
  • (user_pk) — UUID — Foreign key → Untitled.pk — NOT NULL
  • Field (user_name) — string
  • Field2 (content) — string
  • Field3 (createdAt) — Date
  • Field4 (updateAt) — Date
  • Field7 (boardPatchLog) — BoardPatchLog[]
  • Field8 (boardCommentLike) — BoardCommentLike[]