HandCloset

Tables (5)

clothes

  • id — bigint(19) — Primary key — NOT NULL — Auto_Increment
  • category — varchar(255)
  • subcategory — varchar(255)
  • season — varchar(255)
  • color — varchar(255)
  • description — varchar(255) — NOT NULL
  • wearcnt — integer(10) — NOT NULL
  • createdate — timestamp(26) — NOT NULL
  • imgpath — varchar(255)
  • member_id — bigint(19) — Foreign key → member.member_id — NOT NULL — Auto_Increment

diary

  • id — bigint(19) — Primary key — NOT NULL — Auto_Increment
  • date — date(10)
  • season — varchar(255)
  • thumbnailpath — varchar(255) — NOT NULL
  • note — varchar(255) — NOT NULL
  • memberid — bigint(19)
  • member_id — bigint(19) — Foreign key → member.member_id — NOT NULL — Auto_Increment

diary_image_ids

  • id (id2) — bigint(19) — Foreign key → diary.id — NOT NULL — Auto_Increment
  • diary_id — bigint(19)
  • image_id — bigint(19) — NOT NULL

member

  • member_id — bigint(19) — Primary key — NOT NULL — Auto_Increment
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(500) — NOT NULL
  • gender — varchar(10)
  • regdate — timestamp(26) — NOT NULL

member_role

  • member_id — bigint(19) — Foreign key → member.member_id — NOT NULL — Auto_Increment
  • Field
  • role_id — bigint(19)