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