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