snsProject
Tables (5)
Alarm (알람)
- id (기본키) — int — Primary key — NOT NULL
- alarmType (알람 타입) — AlarmType
- args (Field3) — AlarmArgs
- registerdAt (등록일) — Timestamp
- updatedAt (수정일) — Timestamp
- removedAt (삭제일) — Timestamp
- user (유저) — User — Foreign key → User.id — NOT NULL
Comment (댓글)
- id (기본키) — int — Primary key — NOT NULL
- comment (댓글 내용) — archer(100)
- userName (유저 이름) — varchar(100)
- registeredAt (등록일) — Timestamp
- updatedAt (수정일) — Timestamp
- removedAt (제거일) — Timestamp
- userId (유저 id) — int — Foreign key → User.id — NOT NULL
- postId (게시물 id) — int — Foreign key → Post.id — NOT NULL
Like (좋아요)
- id (기본키) — int — Primary key — NOT NULL
- registerdAt (등록일) — Timestamp
- updatedAt (수정일) — Timestamp
- removedAt (삭제일) — Timestamp
- user (유저) — int — Foreign key → User.id — NOT NULL
- post (게시물) — int — Foreign key → Post.id — NOT NULL
Post (게시물)
- id (기본키) — int — Primary key — NOT NULL
- titlte (제목) — varchar(100)
- body (본문) — varchar(100)
- registerdAt (등록일) — Timestamp
- updatedAt (수정일) — Timestamp
- removedAt (삭제일) — Timestamp
- user (유저) — User — Foreign key → User.id — NOT NULL
User (유저)
- id (기본키) — int — Primary key — NOT NULL
- userName (유저네임) — varchar(100)
- password (비밀번호) — varchar(100)
- role (유저 Role) — UserRole
- registeredAt (등록일) — Timestamp
- updatedAt (수정일) — Timestamp
- removedAt (삭제일) — Timestamp