chart in

Tables (4)

Chart

  • chartId — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • createdDate — TIMESTAMP
  • userId — INT

Storage

  • storageId — INT
  • userId — INT
  • chartId — INT
  • savedDate — TIMESTAMP

User

  • userId — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phoneNumber — VARCHAR(20) — NOT NULL

UserChart

  • userChartId — INT
  • userId — INT
  • chartId — INT
  • createdDate — TIMESTAMP