UMC-ENTP

Tables (13)

hobby_group

  • id — INT — Primary key — NOT NULL
  • name — BIGINT — Foreign key → user_group.group_id
  • title — VARCHAR(50)
  • content — VARCHAR(50)

hobby_post

  • group_id — BIGINT — Primary key — NOT NULL
  • id — BIGINT
  • user_id — BIGINT

project_group_tag

  • group_id — BIGINT
  • tag_id — BIGINT — Foreign key → project_tag.id

project_post

  • id — BIGINT
  • group_id — BIGINT
  • user_id — BIGINT — Foreign key → user.id
  • title — VARCHAR(50)
  • content — TEXT

project_stack

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)

project_tag

  • id — BIGINT — Primary key — NOT NULL
  • tag_name — VARCHAR(50)

project_user

  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • group_id — BIGINT

study_group

  • id — BIGINT — Primary key — NOT NULL
  • name — BIGINT
  • title — VARCHAR(50)
  • content — VARCHAR(50)
  • period — INT
  • start_date — DATETIME

study_group_tag

  • group_id — BIGINT — Foreign key → study_group.id
  • tag_id — BIGINT — Foreign key → study_tag.id

study_post

  • id — BIGINT
  • group_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(50)
  • content — TEXT

study_tag

  • id — BIGINT — Primary key — NOT NULL
  • tag_name — BIGINT

user

  • id — BIGINT
  • name — VARCHAR(50) — 유저이름
  • nickname — VARCHAR(50) — 닉네임
  • school — VARCHAR(50) — 학교

user_group

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL — 유저 아이디
  • group_id — BIGINT — Foreign key → study_group.id — NOT NULL — 속한 그룹
  • status — INT — NOT NULL — 현재 가입 여부
  • content — TEXT — 자기소개