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