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