InterparkERD

Tables (9)

Untitled (회원)

  • Key (id) — char(20) — Primary key — NOT NULL
  • Field (name) — varchar(30)
  • Field (num) — char(20)
  • Field (phone) — char(20)
  • Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (판매자)

  • Key (id) — char(20) — Primary key — NOT NULL
  • Field (상호) — varchar(40)
  • Field (ceo) — char(20)
  • Field (연락처) — char(20)
  • Field (fax) — char(20)
  • Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (상품)

  • Key (code) — chart(20) — Primary key — NOT NULL
  • Field (name) — varchar(50)
  • Field (단가) — int
  • Field (단위) — char(4)

Untitled (배송업체)

  • Key (업체코드) — char(5) — Primary key — NOT NULL
  • Field (업체명) — varchar(50)
  • Field (연락처) — char(20)
  • Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (주소)

  • Key (우편번호) — char(5) — Primary key — NOT NULL
  • Field (광역) — char(10)
  • Field (시) — char(10)
  • Field (구) — char(10)
  • Field (번길) — char(10)
  • Field (로) — char(10)

Untitled (판매정보)

  • Key (판매자id) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (code) — chart(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (배송)

  • Key (회원id) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (주문번호) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (주문정보)

  • Key (주문번호) — char(20) — Primary key — NOT NULL
  • Field (갯수) — int
  • Key (id) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (배송일자) — date
  • Field (주문일자) — date
  • Field (주문상태) — char(4)
  • Field
  • Key (배송업체업체코드) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (주문상세)

  • Key (주문번호) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (상품code) — chart(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (개수) — int
  • Key (판매자id) — char(20) — Foreign key → Untitled.Key — NOT NULL