Alumni_Link
Tables (6)
Comment (Untitled3)
- id — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.id — NOT NULL
- post_id — bigint(20) — Foreign key → post.id — NOT NULL
- body — varchar(255)
joinedProject (Untitled5)
- id (ud) — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.id — NOT NULL
- project_id — bigint(20) — Foreign key → project.id — NOT NULL
member (Untitled)
- id — bigint(20) — Primary key — NOT NULL
- email — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- enployed (employed) — varchar(255)
- gitLink — varchar(255)
- resumLink (resumeLink) — varchar(255)
post (Untitled2)
- id — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.id — NOT NULL
- title — varchar(255)
- body — varchar(1000)
- tag — enum
- description — varchar(255)
project (Untitled4)
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- info — varchar(255)
- link — varchar(255)
- leaderName — varchar(255)
- maxCount — int
- nowCount — int
- deadLine — Date
projectMemberRequest (Untitled6)
- id — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.id — NOT NULL
- project_id — bigint(20) — Foreign key → project.id — NOT NULL
- state — boolean