belab_website
Tables (4)
contact_info_board (문의 계시판)
- dashboard_id (계시판_id) — INT — Primary key — NOT NULL
- user_id (사용자_id2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- title (글제목) — VARCHAR(30)
- content (글 내용) — TEXT
- created_at (작성일) — TIMESTAMP
- updated_at (수정일) — TIMESTAMP
notice_board (공지사항)
- notice_id (공지사항_id) — INT — Primary key — NOT NULL
- user_id (사용자_id2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- title (공지사항_제목) — VARCHAR(255)
- content (공지사항 내용) — text
- user_id (사용자_id) — VARCHAR(255)
- file_id (파일_id) — VARCHAR(255)
- created_at (작성일) — TIMESTAMP
- updated_at (수정일) — TIMESTAMP
reference_board (자료실)
- file_id (파일_id) — INT — Primary key — NOT NULL
- user_id (사용자_id2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- user_id (사용자_id) — VARCHAR(50)
- file_name (파일명) — VARCHAR(255)
- file_path (파일경로) — VARCHAR(255)
- file_size (파일크기) — int
- created_at (접속여부) — timestamp
user (사용자)
- user_id (사용자_id) — VARCHAR(255) — Primary key — NOT NULL
- username (사용자 명) — VARCHAR(255)
- password (비밀번호) — VARCHAR(255)
- email (이메일) — VARCHAR(255)
- affiliation (소속) — VARCHAR(255)
- is_active (접속여부) — BOOLEAN
- created_at (가입일) — TIMESTAMP
- updated_at (수정일) — TIMESTAMP