study noise controll

Tables (4)

Concentration (집중도)

  • ID (Concentration_ID) — BIGINT — Primary key — NOT NULL
  • ID (USER_ID) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • CONCENTRATION_RATE (Field) — BIGINT
  • DATETIME (Field2) — DATETIME

NOISE (소음 관리 테이블)

  • ID (NOISE_ID) — BIGINT — Primary key — NOT NULL
  • ID (USER_ID) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • NOISE_PATH (Field) — VARCHAR(255)

Refresh_Tocken (리프레쉬토큰)

  • Id (REFRESH_TOCKEN_ID) — BIGINT — Primary key — NOT NULL
  • ID (USER_ID) — BIGINT — Foreign key → USERS.ID — NOT NULL
  • Value (Field) — VARCHAR(255)

USERS (유저)

  • ID (USER_ID) — BIGINT — Primary key — NOT NULL
  • USERNAME (Field) — VARCHAR(20)
  • PASSWORD (Field2) — VARCHAR(50)
  • NAME (Field3) — VARCHAR(20)
  • EMAIL (Field4) — VARCHAR(50)
  • PHONENUMBER (Field6) — VARCHAR(50)
  • GENDER (Field7) — BOOL