Colorfit
Tables (3)
Color (tb_color)
- id (아이디) — int — Primary key — NOT NULL
- user (username) — foreign key — Foreign key → User.id — NOT NULL
- image (이미지) — image
- date (날짜) — datetime
- spring_rate (봄톤확률) — int
- summer_rate (여름톤확률) — int
- autumn_rate (가을톤확률) — int
- winter_rate (겨울톤확률) — int
Fashion (tb_fashion)
- id (아이디) — int — Primary key — NOT NULL
- user (username) — foreign key — Foreign key → User.id — NOT NULL
- color (퍼스널컬러) — char
- image (이미지) — image
- date (날짜) — datetime
- spring_rate (봄톤확률) — int
- summer_rate (여름톤확률) — int
- autumn_rate (가을톤확률) — int
- winter_rate (겨울톤확률) — int
- result (결과) — char
User (tb_user)
- id (아이디) — int — Primary key — NOT NULL
- username (유저) — char
- nickname (닉네임) — char
- password (비밀번호) — char
- is_active (활성) — boolean
- is_admin (관리자) — boolean
- last_login (최근로그인) — datetime