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)