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