shopping
테이블 (4)
공지사항 (notice)
- noticeno (PK) — NUMBER(10) — 기본 키 — NOT NULL
- title (Field) — VARCHAR2(300) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- wname (Field3) — VARCHAR2(20) — NOT NULL
- passwd (Field4) — VARCHAR2(20)
- cnt (Field5) — NUMBER(10) — NOT NULL
- rdate (Field6) — DATE — NOT NULL
- id (Key) — VARCHAR2(10) — 외래 키 → 회원.id — NOT NULL
상품그룹 (categrp)
- categrpno (Key) — NUMBER(10,0) — 기본 키 — NOT NULL
- grpname (Field) — VARCHAR2(50)
상품분류 (category)
- cateno (Key) — NUMBER(10,0) — 기본 키 — NOT NULL
- catename (Field) — VARCHAR2(50)
- categrpno (Field2) — NUMBER(10,0)
- categrpno (Key2) — NUMBER(10,0) — 외래 키 → 상품그룹.categrpno — NOT NULL
회원 (member)
- id (Key) — VARCHAR(10) — 기본 키 — NOT NULL
- passwd (Field) — VARCHAR(20) — NOT NULL
- mname (Field2) — VARCHAR(20) — NOT NULL
- tel (Field3) — VARCHAR(14)
- email (Field4) — VARCHAR(50) — NOT NULL
- zipcode (Field5) — VARCHAR(7)
- address1 (Field6) — VARCHAR(150)
- address2 (Field7) — VARCHAR(50)
- job (Field8) — VARCHAR(20) — NOT NULL
- mdate (Field9) — DATE — NOT NULL
- fname (Field10) — VARCHAR(50) — NOT NULL
- grade (Field11) — VARCHAR(1) — NOT NULL