store

Tables (12)

Copy Of Copy Of Copy Of Untitled2 (CopyOfCopyOfCopyOfUntitled2)

    Copy Of Copy Of Copy Of Untitled3 (CopyOfCopyOfCopyOfUntitled3)

      Copy Of Copy Of Untitled2 (CopyOfCopyOfUntitled2)

        Copy Of Copy Of Untitled22 (CopyOfCopyOfUntitled22)

          Copy Of Copy Of Untitled23 (CopyOfCopyOfUntitled23)

            Copy Of Untitled2 (CopyOfUntitled2)

              Copy Of Untitled3 (CopyOfUntitled3)

                cart (장바구니)

                • 장바구니 ID (cart_id) — NOT NULL — Primary key — NOT NULL
                • 유저 ID (member_id) — NOT NULL — Foreign key → member.유저 ID — NOT NULL
                • 생성날짜 (created_at) — NOT NULL
                • 수정날짜 (updated_at) — NOT NULL

                cart_item (장바구니 상품)

                • 장바구니 상품 ID (cart_item_id) — NOT NULL — Primary key — NOT NULL
                • 수량 (quantity) — NOT NULL
                • Field2
                • Field3

                category (카테고리)

                • 카테고리 ID (category_id) — NOT NULL — Primary key — NOT NULL
                • 부모 카테고리 ID (parent_category_id) — NOT NULL
                • 이름 (name) — NOT NULL

                member (유저)

                • 유저 ID (member_id) — NOT NULL — Primary key — NOT NULL
                • 이메일 (email) — NOT NULL
                • 비밀번호 (password) — NOT NULL
                • 주소 (address) — NOT NULL
                • 권한 (role) — NOT NULL
                • 생성날짜 (created_at) — NOT NULL
                • 수정날짜 (updated_at) — NOT NULL

                order (주문)

                • 주문 ID (order_id) — NOT NULL — Primary key — NOT NULL
                • 유저 ID (member_id) — NOT NULL — Foreign key → member.유저 ID — NOT NULL
                • 합계 (total_price) — NOT NULL
                • 주문 상태 (status) — NOT NULL
                • Field