GYEBALJA
Tables (10)
board
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- views — int — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- edu_id — bigint — Foreign key → education.id — NOT NULL
board_img
- id — bigint — Primary key — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- img_path — varchar(255)
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
category
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
department
- id — bigint — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- depth — int — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
- parent_id — bigint — Foreign key → department.id
edu_tag
- id — bigint — Primary key — NOT NULL
- edu_id — bigint — Foreign key → education.id — NOT NULL
- tag_id — bigint — Foreign key → tag.id — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
education
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- total_hours — int — NOT NULL
- type — enum — NOT NULL
- place — varchar(255)
- user_id — bigint — Foreign key → user.id — NOT NULL
- category_id — bigint — Foreign key → category.id — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
likes
- id — bigint — Primary key — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
tag
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(15) — NOT NULL
- eng_name — varchar(15)
- gabia_user_no — bigint — NOT NULL
- gender — enum — NOT NULL
- phone — varchar(15)
- tel — varchar(15)
- created_date — datetime — NOT NULL
- modified_date — datetime — NOT NULL
- position_id — bigint — NOT NULL
- position_name — varchar(30) — NOT NULL
- dept_id — bigint — Foreign key → department.id — NOT NULL
- profile_img — varchar(255)