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