MyCloset

Tables (9)

category

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — NOT NULL
  • name — varchar(50)
  • created_at — datetime

closet

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • name — varchar(50)
  • created_at — datetime

cloth

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • closet_id — bigint — NOT NULL
  • category_id — bigint — NOT NULL
  • file_id — bigint — NOT NULL
  • name — varchar(50)
  • is_favorite — char(1)
  • created_at — datetime
  • updated_at — datetime

cloth_season

  • season — VARCHAR(255) — Primary key — NOT NULL
  • cloth_id — bigint — Foreign key → cloth.id — NOT NULL

cloth_tag

  • cloth_id — bigint — Foreign key → cloth.id — NOT NULL
  • tag_id — bigint — Foreign key → tag.id — NOT NULL
  • created_at — datetime

delete_user

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • role — VARCHAR(255)
  • nickname — VARCHAR(255)
  • email — VARCHAR(255)
  • joined_at — VARCHAR(255)
  • created_at — VARCHAR(255)

file

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • url — varchar(255)
  • size — bigint
  • type — varchar(50)
  • created_at — datetime
  • updated_at — datetime

tag

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • created_at — datetime

user

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(50)
  • password — varchar(255)
  • name — varchar(50)
  • role — varchar(20)
  • nickname — varchar(50)
  • email — varchar(100)
  • refresh_token — varchar(255)
  • created_at — datetime
  • updated_at — datetime