mutsa_week5
Tables (7)
Address (Untitled5)
- id (주소ID) — Long — Primary key — NOT NULL
- id (유저ID) — Long — Foreign key → User.id — NOT NULL
- addresName (주소지명) — String
- address (주소지) — String
- zipCode (우편번호) — String
- phoneNumber (전화번호) — String
Cart (Untitled)
- id (카트ID) — Long — Primary key — NOT NULL
- user_id (유저ID) — Long — Foreign key → User.id — NOT NULL
CartItem (Untitled2)
- id (아이템ID) — Long — Primary key — NOT NULL
- quantity (수량) — Long
- cart_id (카트ID) — Long — Foreign key → Cart.id — NOT NULL
- product_id (상품ID) — Long — Foreign key → Product.id — NOT NULL
Order (Untitled6)
- id (주문ID) — Long — Primary key — NOT NULL
- id (유저ID) — Long — Foreign key → User.id — NOT NULL
- id (주소ID) — Long — Foreign key → Address.id — NOT NULL
OrderItem (Untitled7)
- id (주문아이템ID) — Long — Primary key — NOT NULL
- id (주문ID) — Long — Foreign key → Order.id — NOT NULL
- id (상품ID) — Long — Foreign key → Product.id — NOT NULL
- orderPrice (주문가격) — Int
- quantity (주문수량) — Int
Product (Untitled3)
- id (상품ID) — Long — Primary key — NOT NULL
- name (이름) — String
- price (가격) — Int
- stock (재고) — Int
User (Untitled4)
- id (유저ID) — Long — Primary key — NOT NULL
- email (이메일) — String
- password (비밀번호) — String
- name (이름) — String