interpark_erd
Tables (9)
Untitled (회원)
- Key (id) — char(20) — Primary key — NOT NULL
- Field (이름) — varchar(20)
- Field (전화번호) — char(20)
- Field (휴대폰) — char(20)
Untitled (판매자)
- Key (id) — char(20) — Primary key — NOT NULL
- Field (상호) — varchar(20)
- Field (대표자) — char(20)
- Field (연락처) — char(20)
- Field (팩스) — char(20)
- Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (상품)
- Key (코드) — char(20) — Primary key — NOT NULL
- Field (상품명) — varchar(20)
- 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 (번길) — varchar(20
- Field (로) — char(10)
- Field
- Field2
- Field3
Untitled (배송지)
- Key (id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (주문번호)
- Key (주문번호) — char(20) — Primary key — NOT NULL
- Key (id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (갯수) — int
- Field (배송일자) — date
- Field (주문일자) — date
- Field (주문상태) — char(4)
- Key (업체) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (판매정보)
- Key (코드) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (id) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (주문상세)
- Key (주문번호) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (코드) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (갯수) — int