kd9_lifestyle

Tables (3)

Copy Of member (CopyOfmember)

  • memberno — NUMBER(10) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • id — VARCHAR(30) — NOT NULL
  • passwd — VARCHAR(200) — NOT NULL
  • mname — VARCHAR(30) — NOT NULL
  • tel — VARCHAR(14) — NOT NULL
  • zipcode — VARCHAR(5)
  • address1 — VARCHAR(80)
  • address2 — VARCHAR(50)
  • mdate — DATE — NOT NULL
  • grade — NUMBER(2) — NOT NULL

contentsgood

  • contentsgoodno — NUMBER(10) — Primary key — NOT NULL
  • rdate — DATE — NOT NULL
  • contentsno — NUMBER(10) — NOT NULL
  • memberno — NUMBER(10) — NOT NULL

member

  • memberno — NUMBER(10) — Primary key — NOT NULL
  • id — VARCHAR(30) — NOT NULL
  • passwd — VARCHAR(200) — NOT NULL
  • mname — VARCHAR(30) — NOT NULL
  • tel — VARCHAR(14) — NOT NULL
  • zipcode — VARCHAR(5)
  • address1 — VARCHAR(80)
  • address2 — VARCHAR(50)
  • mdate — DATE — NOT NULL
  • grade — NUMBER(2) — NOT NULL