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