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