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