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)