ERD
Tables (6)
Buyer (거래처정보)
- BUYER_ID (거래처코드) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
Buyprod (입고상품정보)
- Key — Primary key — NOT NULL
- Key (Key22) — Foreign key → Prod.PROD_BUYER — NOT NULL
- BUY_PROD (상품코드) — varchar2(10) — Foreign key → Prod.PROD_ID — NOT NULL
- Field
- Field2
- Field3
- Field4
Cart (장바구니(주문내역))
- CART_MEMBER (회원 ID) — varchar2(15) — Foreign key → Member.MEM_ID
- CART_NO (주문번호) — char(13) — Foreign key → Prod.PROD_BUYER — NOT NULL
- CART_PROD (상품코드) — varchar2(10) — Foreign key → Prod.PROD_ID — NOT NULL
- CART_QTY (Field4)
Lprod (상품분류정보)
- LPROD_GU (상품분류코드) — char(4) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
Member (회원정보)
- MEM_ID (회원 ID) — varchar2(15) — Primary key
- MEM_PASS (비밀번호) — varchar2(15)
- MEM_NAME (성명) — varchar2(20)
- MEM_REGNO1 (주민등록번호 앞 6자리) — char(6)
- MEM_REGNO2 (주민등록번호 뒤 7자리) — char(7)
- MEM_BIR (생일) — date
- MEM_ZIP (우편번호) — char(7)
- MEM_ADD1 (주소1) — varchar2(100)
- MEM_ADD2 (주소2) — varchar2(80)
- MEM_HOMETEL (집전화번호) — varchar2(14)
- MEM_COMTEL (회사전화번호) — varchar2(14)
- MEM_HP (이동전화) — varchar2(15)
- MEM_MAIL (E-Mail주소) — varchar2(60)
- MEM_JOB (직업) — varchar2(40)
- MEM_LIKE (취미) — varchar2(40)
- MEM_MEMORIAL (기념일명) — varchar2(40)
- MEM_MEMORIALDAY (기념일날짜) — date
- MEM_MILEAGE (마일리지) — number(10)
- MEM_DELETE (삭제여부) — varchar2(1)
Prod (상품정보)
- PROD_BUYER (공급업체(코드)) — char(6) — Foreign key → Buyer.BUYER_ID — NOT NULL
- PROD_ID (상품코드) — varchar2(10) — Foreign key → Lprod.LPROD_GU — NOT NULL
- Field
- Field2
- Field3
- Field4