style
Tables (7)
member
- id — INT(11) — Primary key — NOT NULL
- user — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
product
- id — INT(11) — Primary key — NOT NULL
- shop_id — INT(11) — Foreign key → shop.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- INDEX — `FK_product_shop`
shop
- id — INT(11) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- shop_id — VARCHAR(50)
- password — VARCHAR(50)
style
- id — INT(11) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
style_member_mapping
- style_id — INT(11) — Foreign key → style.id — NOT NULL
- member_id — INT(11) — Foreign key → member.id — NOT NULL
- INDEX — `FK_style_member_mapping_member`
style_product_mapping
- style_id — INT(11) — Foreign key → style.id — NOT NULL
- product_id — INT(11) — Foreign key → product.id — NOT NULL
- INDEX — `FK_style_product_mapping_product`
style_shop_mapping
- style_id — INT(11) — Foreign key → style.id — NOT NULL
- shop_id — INT(11) — Foreign key → shop.id — NOT NULL
- INDEX — `FK_style_shop_mapping_shop`