JisikIn

Tables (7)

Comment (Untitled2)

  • comment_id (PK) — bigint — Primary key — NOT NULL
  • post_id (게시글 아이디) — bigint — Foreign key → Post.post_id — NOT NULL
  • user_id (사용자 아이디) — bigint — Foreign key → User.user_id — NOT NULL
  • content (댓글 내용) — varchar(255)

HashTag (Untitled6)

  • hashtag_id (PK) — bigint — Primary key — NOT NULL
  • content (해시태그 내용) — varchar(255)

Image (Untitled4)

  • image_id (PK) — bigint — Primary key — NOT NULL
  • post_id (게시글 아이디) — bigint — Foreign key → Post.post_id — NOT NULL
  • image_url (이미지 경로) — varchar(255)

Post (Untitled)

  • post_id (PK) — bigint — Primary key — NOT NULL
  • user_id (사용자 아이디) — bigint — Foreign key → User.user_id — NOT NULL
  • title (제목) — varchar(255)
  • content (내용) — varchar(255)
  • post_type ((질문글, 답변글)) — enum('ANSWER', 'QUESTION')
  • parent_post_id (부모 게시글 아이디) — bigint — Foreign key → Post.post_id — NOT NULL

PostHashTag (Untitled7)

  • post_hashtag_id (PK) — bitint — Primary key — NOT NULL
  • post_id (게시글 아이디) — bigint — Foreign key → Post.post_id — NOT NULL
  • hashtag_id (해시태그 아이디) — bigint — Foreign key → HashTag.hashtag_id — NOT NULL

PostThumb (Untitled3)

  • postthumb_id (PK) — bigint — Primary key — NOT NULL
  • post_id (PK2) — bigint — Foreign key → Post.post_id — NOT NULL
  • user_id (PK3) — bigint — Foreign key → User.user_id — NOT NULL

User (Untitled5)

  • user_id (PK) — bigint — Primary key — NOT NULL
  • name (사용자 이름) — varchar(255)
  • nickname (닉네임) — varchar(255)