test
Tables (10)
equipment
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- type — ENUM('RACKET', 'SHOE') — NOT NULL
- purchase_date — DATE
- price — INT
- memo — VARCHAR(500)
- retired_at — DATE
- created_at — DATETIME
- updated_at — DATETIME
grip_model (grip)
- id — BIGINT — Primary key — NOT NULL
- brand — VARCHAR(100)
- name — VARCHAR(100) — NOT NULL
- type (Field) — ENUM('over', 'towel', 'cushion' )
member
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(30) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100)
- email_verified — BOOLEAN
- nickname — VARCHAR(20) — NOT NULL
- birth_date — DATE
- gender — ENUM('남', '여')
- local_class — ENUM('자강','A','B','C','D','E','F')
- national_class — ENUM('자강','A','B','C','D','E','F')
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
my_racket
- id — BIGINT — Primary key — NOT NULL
- equipment_id — BIGINT — Foreign key → equipment.id — NOT NULL
- racket_model_id — BIGINT — Foreign key → racket_model.id — NOT NULL
my_shoes
- id — BIGINT — Primary key — NOT NULL
- equipment_id — BIGINT — Foreign key → equipment.id — NOT NULL
- shoe_model_id — BIGINT — Foreign key → shoe_model.id — NOT NULL
racket_grip_history
- id — BIGINT — Primary key — NOT NULL
- my_racket_id — BIGINT — Foreign key → my_racket.id — NOT NULL
- grip_model_id — BIGINT — Foreign key → grip_model.id — NOT NULL
- wrapped_at — DATE — NOT NULL
- memo — VARCHAR(500)
- created_at — DATETIME
racket_model
- id — BIGINT — Primary key — NOT NULL
- brand — VARCHAR(50) — NOT NULL
- series — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- weight — ENUM('2U','3U','4U','5U','6U')
- balance — VARCHAR(50)
- flex — VARCHAR(50)
racket_string_history
- id — BIGINT — Primary key — NOT NULL
- my_racket_id — BIGINT — Foreign key → my_racket.id — NOT NULL
- string_model_id — BIGINT — Foreign key → string_model.id — NOT NULL
- tension — INT
- strung_at — DATE — NOT NULL
- memo — VARCHAR(500)
- created_at — DATETIME
shoe_model
- id — BIGINT — Primary key — NOT NULL
- brand — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- width — VARCHAR(20)
string_model (string)
- id — BIGINT — Primary key — NOT NULL
- brand — VARCHAR(100)
- name — VARCHAR(100) — NOT NULL