machoman

Tables (3)

comment (댓글)

  • comment_id (인덱스) — PK AI — Primary key — NOT NULL
  • user_id (유저 외래키) — FK — Foreign key → user.user_id — NOT NULL
  • post_id (게시글 외래키) — FK — Foreign key → post.post_id — NOT NULL
  • comment (댓글) — NotNull — NOT NULL
  • created_at (생성일) — NotNull — NOT NULL
  • updated_at (업데이트일) — NotNull — NOT NULL

post (게시글)

  • post_id (인덱스) — PK AI — Primary key — NOT NULL
  • user_id (유저 외래키) — FK — Foreign key → user.user_id — NOT NULL
  • title (제목) — NotNull — NOT NULL
  • content (내용) — NotNull — NOT NULL
  • image (이미지) — NotNull — NOT NULL
  • created_at (생성일) — NotNull — NOT NULL
  • updated_at (업데이트일) — NotNull — NOT NULL

user (유저)

  • user_id (인덱스) — PK AI — Primary key — NOT NULL
  • email (이메일) — NotNull — NOT NULL
  • password (비밀번호) — NotNull
  • nickname (닉네임) — NotNull — NOT NULL
  • created_at (생성일) — NotNull — NOT NULL
  • updated_at (업데이트일) — NotNull — NOT NULL