Capstone-Design-DB

Tables (12)

admin

  • ID (id) — BIGINT, AUTO_INCREMENT — Primary key — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 이름 (name) — VARCHAR(255) — NOT NULL
  • 권한 (role) — ENUM('ADMIN', 'USER') DEFAULT 'ADMIN' — NOT NULL
  • role_id — INT, AUTO INCREMENT — Foreign key → role.role_id — NOT NULL

board

  • board_id — BIGINT, AUTO INCREMENT — Primary key — NOT NULL
  • content — TEXT
  • like_count — INT
  • user_id — VARCHAR(255) — Foreign key → users.userid
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • title — varchar(255)

board_like

  • id — bigint, auto_increment — Primary key — NOT NULL
  • board_id — BIGINT, AUTO INCREMENT — Foreign key → board.board_id — NOT NULL
  • userid (user_id) — VARCHAR(255) — Foreign key → users.userid — NOT NULL
  • created_at — datetime — NOT NULL

comment_entity

  • id — bigint, auto_increment — Primary key — NOT NULL
  • board_id — BIGINT, AUTO INCREMENT — Foreign key → board.board_id
  • userid (user_id) — VARCHAR(255) — Foreign key → users.userid
  • content — text
  • like_count — int
  • created_at — datetime(6)

comment_like

  • id — bigint, auto_increment — Primary key — NOT NULL
  • comment_id — bigint, auto_increment — Foreign key → comment_entity.id — comment_entity(id)
  • userid (user_id) — VARCHAR(255) — Foreign key → users.userid
  • created_at — datetime(6) — NOT NULL

email_auth

  • id — BIGINT, AUTO_INCREMENT — Primary key — NOT NULL
  • code — VARCHAR(255) — NOT NULL
  • created_at — timestamp default current_timestamp — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • email — varchar(255) — NOT NULL

major

  • 학과코드 (major_code) — BIGINT — Primary key — NOT NULL
  • 학과 (major) — VARCHAR(255), UNIQUE — NOT NULL

post

  • id — bigint, auto_increment — Primary key — NOT NULL
  • userid (user_id) — VARCHAR(255) — Foreign key → users.userid
  • Field (content) — text
  • Field (title) — varchar(255)
  • Field (view_count) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

role

  • role_id — INT, AUTO INCREMENT — Primary key — NOT NULL
  • role — VARCHAR(255) — NOT NULL

student_subject

  • student_number — VARCHAR(255) — Foreign key → users.userid — NOT NULL
  • 교과목명 (subject_name) — VARCHAR(255) — Foreign key → subject.과목코드 — NOT NULL

subject

  • 과목코드 (subject_code) — VARCHAR(255) — Primary key — NOT NULL
  • 교과목명 (subject_name) — VARCHAR(255) , UNIQUE — NOT NULL
  • 학점 (score) — INT
  • 카테고리 (category) — VARCHAR(255)
  • 학과코드 (major_code) — BIGINT — Foreign key → major.학과코드
  • 학과 (major) — VARCHAR(255) — Foreign key → major.학과코드

users

  • userid (user_id) — VARCHAR(255) — Primary key — NOT NULL
  • major — VARCHAR(255) — Foreign key → major.학과코드 — NOT NULL
  • pwd — varchar(255) — NOT NULL
  • student_number — varchar(255), UNIQUE — NOT NULL
  • user_name — varchar(255) — NOT NULL
  • role_id — INT, AUTO INCREMENT — Foreign key → role.role_id — NOT NULL