LGCNS_BLOG

Tables (8)

BOARD

  • board_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • 게시글 제목 (title) — VARCHAR(100)
  • 게시글 내용 (content) — VARCHAR(500)
  • 생성일 (created_at) — DATETYPE
  • 수정일 (updated_at) — DATETYPE
  • 조회수 (view_count) — INT
  • 좋아요수 (like_count) — INT

BOARD (STUDYCOMMUNITY)

  • board_id — INT — Foreign key → BOARD.board_id — NOT NULL
  • user_id — INT — Foreign key → BOARD.user_id — NOT NULL
  • 모집 명수 (recruit_count) — INT
  • 현재 모집된 인원수 (current_count) — INT
  • start_date — DATETYPE
  • end_date — DATETYPE

BOARD (HASHTAG)

  • hashtagId — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → BOARD.board_id — NOT NULL
  • hashtagname (name) — VARCHAR(100)

COMMENT

  • comment_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → BOARD.board_id — NOT NULL
  • user_id — INT — Foreign key → BOARD.user_id — NOT NULL
  • 댓글 내용 (CONTENT) — VARCHAR(100)
  • 작성일 (created_at) — DATETYPE

USER

  • user_id — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(100)
  • 비밀번호 (password) — VARCHAR(100)
  • 이름 (name) — VARCHAR(100)
  • 생년월일 (birthday) — DATETYPE

USER (USER_SCRAB)

  • userscrab_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → BOARD.board_id — NOT NULL
  • user_id — INT — Foreign key → BOARD.user_id — NOT NULL
  • 스크랩,좋아요 (like_Type) — VARCHAR(20)

USER (USER_TODOLIST)

  • todo_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • content — VARCHAR(200)
  • is_done — BOOLEAN
  • start_date — DATETYPE
  • end_date — DATETYPE

USER (USER_RANK)

  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • 포스트수 (post_count) — INT
  • 댓글 수 (comment_count) — INT
  • 점수 (score) — BIGINT
  • 수정일 (update_at) — DATETYPE