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