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