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 — 자기소개