DBA_Portfolio
Tables (8)
Category (카테고리)
- category_id (카테고리번호) — BIGINT — Primary key — NOT NULL
- category_name (카테고리명) — VARCHAR(50)
Delivery (배송)
- delievery_id (배송번호) — BIGINT — Primary key — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
- recipient_name (수령인) — VARCHAR(50)
- recipient_phone (연락처) — VARCHAR(20)
- address (주소) — VARCHAR(255)
- delivery_status (배송상태) — VARCHAR(20)
- shipped_at (출고일) — DATETIME
- delivered_at (배송완료일) — DATETIME
Member (회원)
- member_id (회원번호) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(100)
- password (비밀번호) — VARCHAR(255)
- member_name (이름) — VARCHAR(50)
- phone (전화번호) — VARCHAR(20)
- created_at (가입일) — DATETIME
- updated_at (수정일) — DATETIME
OrderItem (주문상세)
- order_item_id (주문상품번호) — BIGINT — Primary key — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
- product_id (상품번호) — BIGINT — Foreign key → Product.product_id — NOT NULL
- quantity (주문수량) — INT
- order_price (주문당시가격) — INT
Orders (주문)
- order_id (주문번호) — BIGINT — Primary key — NOT NULL
- member_id (회원번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
- order_date (주문날짜) — DATETIME
- total_price (총 주문금액) — INT
- order_status (주문상태) — VARCHAR(20)
Payment (결제)
- payment_id (결제번호) — BIGINT — Primary key — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
- payment_method (결제수단) — VARCHAR(20)
- payment_amount (결제금액) — INT
- payment_status (결제상태) — VARCHAR(20)
- payment_date (결제일시) — DATETIME
Product (상품)
- product_id (상품번호) — BIGINT — Primary key — NOT NULL
- category_id (카테고리번호) — BIGINT — Foreign key → Category.category_id — NOT NULL
- product_name (상품명) — VARCHAR(50)
- price (가격) — INT
- stock (재고) — INT
- created_at (등록일) — DATETIME
- updated_at (수정일) — DATETIME
- description (설명) — TEXT
Review (리뷰)
- review_id (리뷰번호) — BIGINT — Primary key — NOT NULL
- member_id (회원번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
- order_item_id (주문상품번호) — BIGINT — Foreign key → OrderItem.order_item_id — NOT NULL
- rating (평점) — INT
- content (리뷰내용) — TEXT
- created_at (작성일) — DATETIME