Welive_ERD

Tables (13)

Apartment

  • id — TEXT — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • address — TEXT — NOT NULL
  • officeNumber — TEXT — NOT NULL
  • description — TEXT — NOT NULL
  • startComplexNumber — INTEGER — NOT NULL
  • endComplexNumber — INTEGER — NOT NULL
  • startDongNumber — INTEGER — NOT NULL
  • endDongNumber — INTEGER — NOT NULL
  • startFloorNumber — INTEGER — NOT NULL
  • endFloorNumber — INTEGER — NOT NULL
  • startHoNumber — INTEGER — NOT NULL
  • endHoNumber — INTEGER — NOT NULL
  • apartmentStatus — "ApartmentStatus" — NOT NULL
  • adminId — TEXT — Foreign key → User.id
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

ApartmentSchedule

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • noticeId — TEXT — Foreign key → Notice.id
  • title — TEXT — NOT NULL
  • description — TEXT
  • startDate — TIMESTAMP(3) — NOT NULL
  • endDate — TIMESTAMP(3) — NOT NULL
  • createdById — TEXT — Foreign key → User.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

AuthSession

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — Foreign key → User.id — NOT NULL
  • refreshTokenHash — TEXT — NOT NULL
  • userAgent — TEXT
  • ipAddress — TEXT
  • expiresAt — TIMESTAMP(3) — NOT NULL
  • revokedAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL

Board

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • type — "BoardType" — NOT NULL
  • name — TEXT — NOT NULL
  • isActive — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Comment

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT
  • boardType — "BoardType" — NOT NULL
  • boardId — TEXT — NOT NULL
  • authorId — TEXT — Foreign key → User.id — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

Complaint

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • boardId — TEXT — Foreign key → Board.id
  • authorId — TEXT — Foreign key → User.id — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • isPublic — BOOLEAN — NOT NULL
  • status — "ComplaintStatus" — NOT NULL
  • building — TEXT
  • unitNumber — TEXT
  • viewsCount — INTEGER — NOT NULL
  • commentsCount — INTEGER — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

Notice

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • authorId — TEXT — Foreign key → User.id — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • category — "NoticeCategory" — NOT NULL
  • importance — "NoticeImportance" — NOT NULL
  • isPinned — BOOLEAN — NOT NULL
  • viewsCount — INTEGER — NOT NULL
  • commentsCount — INTEGER — NOT NULL
  • pollId — TEXT — Foreign key → Poll.id
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

Notification

  • id — TEXT — Primary key — NOT NULL
  • receiverId — TEXT — Foreign key → User.id — NOT NULL
  • type — "NotificationType" — NOT NULL
  • title — TEXT — NOT NULL
  • message — TEXT — NOT NULL
  • relatedBoardType — "BoardType"
  • relatedBoardId — TEXT
  • isRead — BOOLEAN — NOT NULL
  • readAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL

Poll

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • boardId — TEXT — Foreign key → Board.id — NOT NULL
  • authorId — TEXT — Foreign key → User.id — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • status — "PollStatus" — NOT NULL
  • targetType — "PollTargetType" — NOT NULL
  • buildingPermission — INTEGER — NOT NULL
  • startDate — TIMESTAMP(3) — NOT NULL
  • endDate — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

PollOption

  • id — TEXT — Primary key — NOT NULL
  • pollId — TEXT — Foreign key → Poll.id — NOT NULL
  • title — TEXT — NOT NULL
  • sortOrder — INTEGER — NOT NULL
  • voteCount — INTEGER — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

PollVote

  • id — TEXT — Primary key — NOT NULL
  • pollId — TEXT — Foreign key → Poll.id — NOT NULL
  • optionId — TEXT — Foreign key → PollOption.id — NOT NULL
  • userId — TEXT — Foreign key → User.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ResidentRoster

  • id — TEXT — Primary key — NOT NULL
  • apartmentId — TEXT — Foreign key → Apartment.id — NOT NULL
  • name — TEXT — NOT NULL
  • contact — TEXT — NOT NULL
  • building — TEXT — NOT NULL
  • unitNumber — TEXT — NOT NULL
  • isHouseholder — "HouseholderType" — NOT NULL
  • occupancyStatus — "ResidentOccupancyStatus" — NOT NULL
  • userId — TEXT — Foreign key → User.id
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)

User

  • id — TEXT — Primary key — NOT NULL
  • username — TEXT — NOT NULL
  • passwordHash — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • contact — TEXT — NOT NULL
  • role — "Role" — NOT NULL
  • approvalStatus — "ApprovalStatus" — NOT NULL
  • isRegistered — BOOLEAN — NOT NULL
  • isHouseholder — "HouseholderType"
  • building — TEXT
  • unitNumber — TEXT
  • profileImageUrl — TEXT
  • apartmentId — TEXT — Foreign key → Apartment.id
  • approvedById — TEXT — Foreign key → User.id
  • approvedAt — TIMESTAMP(3)
  • rejectedReason — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • deletedAt — TIMESTAMP(3)