Teampl
Tables (20)
ChatRead
- id — SERIAL — Primary key — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- roomKey — VARCHAR(255) — NOT NULL
- lastReadMsgId — INTEGER — NOT NULL
- updatedAt — TIMESTAMP — NOT NULL
DriveFile
- id — SERIAL — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id — NOT NULL
- folderId — INTEGER — Foreign key → DriveFolder.id
- name — VARCHAR(255) — NOT NULL
- originalName — VARCHAR(255) — NOT NULL
- type — VARCHAR(100) — NOT NULL
- size — INTEGER — NOT NULL
- url — TEXT — NOT NULL
- uploaderEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
DriveFolder
- id — SERIAL — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- theme — VARCHAR(100) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- creatorEmail — VARCHAR(255) — Foreign key → User.email
- parentFolderId — INTEGER — Foreign key → DriveFolder.id
EmailVerification
- id — SERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- code — VARCHAR(100) — NOT NULL
- expiresAt — TIMESTAMP — NOT NULL
- isVerified — BOOLEAN — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
Message
- id — SERIAL — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id
- senderEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- receiverEmail — VARCHAR(255) — Foreign key → User.email
- content — TEXT — NOT NULL
- isPinned — BOOLEAN — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
Notification
- id — SERIAL — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- isRead — BOOLEAN — NOT NULL
- link — TEXT
- createdAt — TIMESTAMP — NOT NULL
PaymentCard
- id — SERIAL — Primary key — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- cardCompany — VARCHAR(100) — NOT NULL
- maskedNumber — VARCHAR(100) — NOT NULL
- expiryMonth — VARCHAR(10) — NOT NULL
- expiryYear — VARCHAR(10) — NOT NULL
- cardHolder — VARCHAR(100) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
Project
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- course — VARCHAR(255)
- description — TEXT
- progress — INTEGER — NOT NULL
- deadline — VARCHAR(100) — NOT NULL
- members — INTEGER — NOT NULL
- color — VARCHAR(100)
- icon — VARCHAR(100)
- inviteCode — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- customStages — JSONB
- aiEvaluationScore — INTEGER
- aiEvaluationReport — JSONB
- createdAt — TIMESTAMP — NOT NULL
ProjectDeleteAlert
- id — SERIAL — Primary key — NOT NULL
- userEmail — VARCHAR(255) — NOT NULL
- projectName — VARCHAR(255) — NOT NULL
- deleteReason — TEXT — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
ProjectMember
- id — SERIAL — Primary key — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- projectId — INTEGER — Foreign key → Project.id — NOT NULL
- role — "ProjectRole" — NOT NULL
- status — "MemberStatus" — NOT NULL
- kickReason — TEXT
- joinedAt — TIMESTAMP — NOT NULL
PushSubscription
- id — SERIAL — Primary key — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- endpoint — TEXT — NOT NULL
- p256dh — TEXT — NOT NULL
- auth — TEXT — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
Schedule
- id — SERIAL — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id
- title — VARCHAR(255) — NOT NULL
- date — VARCHAR(100) — NOT NULL
- endDate — VARCHAR(100)
- type — VARCHAR(100) — NOT NULL
- color — VARCHAR(100) — NOT NULL
- dot — VARCHAR(100) — NOT NULL
- ownerEmail — VARCHAR(255)
Task
- id — UUID — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- status — "TaskStatus" — NOT NULL
- priority — "TaskPriority" — NOT NULL
- deadline — VARCHAR(100) — NOT NULL
- ownerEmail — VARCHAR(255)
- assignees — TEXT — NOT NULL
- unreadCommentBy — TEXT — NOT NULL
- requiresDeliverable — BOOLEAN — NOT NULL
- completedAt — TIMESTAMP
- createdAt — TIMESTAMP — NOT NULL
- submitterEmail — VARCHAR(255)
TaskApproval
- id — SERIAL — Primary key — NOT NULL
- taskId — UUID — Foreign key → Task.id — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
TaskComment
- id — SERIAL — Primary key — NOT NULL
- taskId — UUID — Foreign key → Task.id — NOT NULL
- userEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- content — TEXT — NOT NULL
- isAnonymous — BOOLEAN — NOT NULL
- anonymousName — VARCHAR(100)
- createdAt — TIMESTAMP — NOT NULL
TaskDeliverable
- id — SERIAL — Primary key — NOT NULL
- taskId — UUID — Foreign key → Task.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- originalName — VARCHAR(255) — NOT NULL
- type — VARCHAR(100) — NOT NULL
- size — INTEGER — NOT NULL
- url — TEXT — NOT NULL
- uploaderEmail — VARCHAR(255) — Foreign key → User.email — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
User
- id — UUID — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — TEXT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- avatarUrl — TEXT
- studentId — VARCHAR(100)
- department — VARCHAR(100)
- plan — "PlanType" — NOT NULL
- aiUsageCount — INTEGER — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
Vote
- id — SERIAL — Primary key — NOT NULL
- projectId — INTEGER — Foreign key → Project.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- isAnonymous — BOOLEAN — NOT NULL
- isMultiple — BOOLEAN — NOT NULL
- deadline — TIMESTAMP
- creatorEmail — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
VoteOption
- id — SERIAL — Primary key — NOT NULL
- voteId — INTEGER — Foreign key → Vote.id — NOT NULL
- text — TEXT — NOT NULL
- order — INTEGER — NOT NULL
VoteRecord
- id — SERIAL — Primary key — NOT NULL
- voteId — INTEGER — Foreign key → Vote.id — NOT NULL
- optionId — INTEGER — Foreign key → VoteOption.id — NOT NULL
- userEmail — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL