SSAFY_sprint

Tables (7)

JobCategory

  • id — BIGINT — Primary key — NOT NULL
  • sprint_id — BIGINT — Foreign key → Topic.sprint_id — NOT NULL
  • name — VARCHAR(50)

Member (user)

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • ssafy_num — VARCHAR(50)
  • name — VARCHAR(10)
  • provider — ENUM
  • point — INT

Sprint

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(15)
  • start_date — DATE
  • end_date — DATE
  • overview — VARCHAR(100)
  • img_url — VARCHAR(50)
  • max_member — INT
  • num_of_current_member — INT

Topic

  • id — BIGINT — Primary key — NOT NULL
  • sprint_id — BIGINT — Foreign key → Sprint.id — NOT NULL
  • name — VARCHAR(50)

Untitled

  • Field (id) — BIGINT — Primary key
  • job_category-id (job_category_id) — BIGINT — Foreign key → JobCategory.id — NOT NULL
  • id (User_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • Field
  • Field2

refresh

  • id — INT — Primary key — NOT NULL
  • username — VARCHAR(255)
  • refresh — VARCHAR(255)
  • expiration — TIMESTAMP

sprint_member

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Member.id — NOT NULL
  • sprint_id (spring_id) — INT — Foreign key → Sprint.id — NOT NULL