SnackMarket
Tables (6)
Untitled (Member)
- Key (memberId) — NUMBER — Primary key — NOT NULL — Sequence
- Field (id) — VARCHAR2(40) — NOT NULL
- Field (password) — VARCHAR2(100) — NOT NULL
- Field (name) — VARCHAR2(20)
- Field (phone) — VARCHAR2(13)
- Field (email) — VARCHAR(200)
- Field (post) — CHAR(5)
- Field (address) — VARCHAR(200)
- Field (createDate) — DATE — NOT NULL
Untitled (Product)
- Key (productId) — NUMBER — Primary key — NOT NULL — Sequence
- Field (name) — VARCHAR2(120) — NOT NULL — 상품명
- Field (price) — NUMBER — NOT NULL
- Field (thumbnail) — VARCHAR2(120) — 상품이미지
- Field (contents) — VARCHAR2(120) — 상세설명(이미지)
- Field (createDate) — DATE — NOT NULL
Untitled (Qna)
- Key (qnaId) — NUMBER — Primary key — NOT NULL — Sequence
- Key (memberId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Member Table FK
- Key (productId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Product Table FK
- Field (content) — VARCHAR2(500) — NOT NULL — 문의내용
- Field (answer) — VARCHAR2(500) — 답변내용
- Field (createDate) — DATE — NOT NULL
- Field (answerDate) — DATE
Untitled (Cart)
- Key (cartId) — NUMBER — Primary key — NOT NULL — Sequence
- Key (productId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Product Table FK
- Key (memberId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Membver Table FK
- Field (count) — NUMBER — NOT NULL
Untitled (Order)
- Key (orderId) — NUMBER — Primary key — NOT NULL — Sequence
- Key (memberId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Member Table FK
- Field (receverName) — VARCHAR2(20) — NOT NULL — 받는사람 정보
- Field (receverPhone) — VARCHAR2(13) — NOT NULL — 받는사람 전화번호
- Field (receverAddress) — VARCHAR2(300) — 받는사람 주소
- Field (deliveryRequest) — VARCHAR2(100) — 배송 요청사항
- Field (pay) — NUMBER — NOT NULL — 내가 지불해야할 금액
- Field (createDate) — DATE — 주문생성
Untitled (OrderProduct)
- Key (OrderProductId) — Primary key — NOT NULL
- Key (orderId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Sequence
- Key (productId) — NUMBER — Foreign key → Untitled.Key — NOT NULL — Sequence
- Field (count) — NUMBER — NOT NULL