BoardService
Tables (3)
comments (댓글)
- id (기본키) — BIGINT — Primary key — NOT NULL
- user_id (유저 번호) — BIGINT — Foreign key → user.id — NOT NULL
- posts_id (게시물 번호) — BIGINT — Foreign key → posts.id — NOT NULL
- comment (코멘트) — TEXT — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
- modified_date (수정일) — DATETIME — NOT NULL
posts (게시물)
- id (기본키) — BIGINT — Primary key — NOT NULL
- user_id (유저 번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (제목) — VARCHAR(255) — NOT NULL
- content (내용) — TEXT — NOT NULL
- writer (작성자) — VARCHAR(255) — NOT NULL
- view (조회수) — BIGINT — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
- modified_date (수정일) — DATETIME — NOT NULL
user (유저)
- id (기본키) — BIGINT — Primary key — NOT NULL
- username (이름) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- nickname (닉네임) — VARCHAR(255) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL