Inus_OCR
Tables (5)
User (일반유저)
- email (이메일) — string — Primary key — NOT NULL
- Kname (한국이름) — string
- password (비밀번호) — string
- provider (제공처) — String
- snsId (sns아이디)
- managerid (관리자id) — string — Foreign key → admin.id — NOT NULL
admin (관리자)
- id (아이디) — string — Primary key — NOT NULL
- pw (비밀번호)
tag (서류 태그)
- id (Key) — Primary key — NOT NULL
- tag (Field)
upload (업로드 서류)
- id (Key) — Primary key — NOT NULL
- img (서류) — img
- email (유저이메일) — string — Foreign key → User.email — NOT NULL
- content (내용) — string
- check (서류승인여부) — bool
uploadTag (n:m 관계)
- uploadid (Key) — Foreign key → upload.id — NOT NULL
- tagid (Key2) — Foreign key → tag.id — NOT NULL