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