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