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
  • mlevel — smallint(1) — Foreign key → mlevel.mlevel — NOT NULL
  • marea — char(1) — Foreign key → area.marea — NOT NULL
  • mname — char(30) — NOT NULL
  • mage — int(3) — NOT NULL
  • memail — varchar(100) — NOT NULL
  • mtel — char(13) — NOT NULL
  • mpost — char(6) — NOT NULL
  • maddr — text — NOT NULL
  • maddr_dtc — varchar(255) — NOT NULL
  • mdate — timestamp — NOT NULL

mlevel (회원등급)

  • lidx — smallint(2) — Primary key — NOT NULL
  • mlevel — smallint(1) — Primary key — NOT NULL
  • levelname — char(40) — NOT NULL