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