solo

Tables (6)

file

  • no — bigint(20) — Primary key — NOT NULL
  • service — int(11)
  • origin — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • ext — varchar(10) — NOT NULL
  • mediaType — varchar(255) — NOT NULL
  • attachPath — varchar(100) — NOT NULL
  • useYn — char(1) — NOT NULL
  • regUserNo — bigint(20) — Foreign key → user.no
  • regDate — timestamp — NOT NULL
  • modUserNo — bigint(20) — Foreign key → user.no
  • modDate — timestamp

role

  • no — bigint(20) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • roleName — varchar(100) — NOT NULL
  • useYn — char(1) — NOT NULL
  • regUserNo — bigint(20) — Foreign key → user.no
  • regDate — timestamp — NOT NULL
  • modUserNo — bigint(20) — Foreign key → user.no
  • modDate — timestamp

role_user

  • no — bigint(20) — Primary key — NOT NULL
  • roleNo — bigint(20) — Foreign key → role.no — NOT NULL
  • userNo — bigint(20) — Foreign key → user.no — NOT NULL
  • useYn — char(1) — NOT NULL
  • regUserNo — bigint(20) — Foreign key → user.no
  • regDate — timestamp — NOT NULL
  • modUserNo — bigint(20) — Foreign key → user.no
  • modDate — timestamp

user

  • no — bigint(20) — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • name — varchar(100) — NOT NULL
  • fileNo — bigint(20)
  • useYn — char(1) — NOT NULL
  • regUserNo — bigint(20) — Foreign key → user.no
  • regDate — timestamp — NOT NULL
  • modUserNo — bigint(20) — Foreign key → user.no
  • modDate — timestamp

v_files

  • cnt — DECIMAL(22,0)

v_users

  • cnt — DECIMAL(22,0)