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[]