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)