superadmin

Tables (4)

admin-company (관리자)

  • id — Primary key — NOT NULL
  • name (이름)
  • phone (핸드폰)
  • email (이메일)
  • createdate (생성일)
  • logo img (로고이미지)
  • createdate (Field)
  • create allow (Field2)

member (사용자)

  • id — Primary key — NOT NULL
  • id (id3) — Foreign key → admin-company.id — NOT NULL
  • name (이름)
  • phone (핸드폰)
  • email (이메일)
  • createdate (생성일)

sub-company (하청업체)

  • id — Primary key — NOT NULL
  • id (id3) — Foreign key → admin-company.id — NOT NULL
  • name (이름)
  • phone (핸드폰)
  • email (이메일)
  • createdate (생성일)
  • create allow (Field)

super admin (슈퍼관리자)

  • id — Primary key — NOT NULL
  • name (이름)
  • phone (핸드폰)
  • email (이메일)
  • createdate (생성일)