gabia internship project

Tables (7)

Authority (권한테이블)

  • (PK) (authority_id) — VARCHAR — Primary key — NOT NULL
  • (authority_showmenu1) — INT
  • (authority_showmenu2) — INT
  • (authority_showmenu3) — INT
  • (authority_showmenu4) — INT

Board (교육홍보게시판테이블)

  • (PK) (board_id) — LONG — Primary key — NOT NULL
  • (board_title) — VARCHAR
  • (board_content) — VARCHAR
  • (board_view) — INT
  • (board_like) — INT
  • (user_id) — VARCHAR
  • (board_written_date) — DATETIME
  • (board_modified_date) — DATETIME
  • (board_img) — VARCHAR

BoardComment (게시판 댓글 테이블)

  • (PK) (comment_ikey) — LONG — Primary key — NOT NULL
  • (comment_contents) — VARCHAR
  • (FK) (user_id) — VARCHAR
  • (comment_written_date) — DATETIME
  • (comment_modified_date) — DATETIME
  • (FK) (board_id) — VARCHAR

Dept (부서 테이블)

  • (PK) (dept_id) — VARCHAR — Primary key — NOT NULL
  • (dept_name) — VARCHAR
  • (dept_parent) — VARCHAR
  • (dept_depth) — INT

Education (교육테이블)

  • (PK) (edu_ikey) — LONG — Primary key — NOT NULL
  • (edu_title) — VARCHAR
  • (edu_content) — VARCHAR
  • (edu_start_date) — DATE
  • (edu_end_date) — DATE
  • (edu_hours) — INT
  • (edu_type) — VARCHAR
  • (edu_place) — VARCHAR
  • (FK) (user_id) — VARCHAR

User (회원테이블)

  • (PK) (user_id) — LONG — Primary key — NOT NULL
  • (user_email) — VARCHAR
  • (user_password) — VARCHAR
  • (user_name) — VARCHAR
  • (user_gender) — CHAR
  • (FK) (user_position_id) — VARCHAR
  • (user_position_name) — VARCHAR
  • (user_phone) — VARCHAR
  • (user_tel) — VARCHAR
  • (FK) (user_dept_id) — VARCHAR

UserEduRelation (회원, 교육 관계테이블)

  • (PK) (useredu_ikey) — LONG — Primary key — NOT NULL
  • (FK) (user_email) — VARCHAR
  • (FK) (edu_id) — VARCHAR