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)