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