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