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