erd
Tables (3)
member (회원)
- memberSeq (Key) — Primary key — NOT NULL
- memberRole (권한)
- name (이름)
- nickname (별명)
- password (비밀번호)
- phonenumber (번호)
- email (이메일)
- gender (성별)
order (주문)
- memberProductSeq (Key) — Primary key — NOT NULL
- memberSeq (회원외래키) — Foreign key → member.memberSeq — NOT NULL
- orderNumber (주문번호)
- productSeq (상품외래키) — Foreign key → product.productSeq — NOT NULL
product (상품)
- productSeq (Key) — Primary key — NOT NULL
- productName (상품이름)