news
Tables (3)
area (지역코드명)
- aidx — smallint(2) — Primary key — NOT NULL
- marea — char(1) — Primary key — NOT NULL
- marea2 — char(10) — NOT NULL
member (회원테이블)
- midx — int(4) — Primary key — NOT NULL — 자동증가값
- mid — varchar(40) — Primary key — NOT NULL
- mhp — char(11) — Primary key — NOT NULL
- lidx — smallint(2) — Foreign key → mlevel.lidx — NOT NULL
- marea (marea2) — char(1) — Foreign key → area.marea — NOT NULL
- Key — Foreign key → mlevel.mlevel — NOT NULL
- mname — char(30) — NOT NULL
- mage — int(2) — NOT NULL
- memail — varchar(100) — NOT NULL
- mtel — char(13) — NOT NULL
- mpost — char(5) — NOT NULL
- maddr — text — NOT NULL
- maddr_dtc — varchar(255) — NOT NULL
- mlevel — smallint(1) — NOT NULL
- marea — char(1) — NOT NULL
- mdate — timestamp — NOT NULL
mlevel (회원등급)
- lidx — smallint(2) — Primary key — NOT NULL
- mlevel — smaillint(1) — Primary key — NOT NULL
- levelname — char(40) — NOT NULL