GCS

Tables (6)

CERT_DETAIL (Untitled)

  • cert_id (id) — int — Foreign key → CERT_KIND.cert_id — NOT NULL
  • User_id (id2) — int — Foreign key → CERT_KIND.User_id — NOT NULL
  • kind (Field) — int
  • content (Field4) — text
  • score (Field2) — int
  • added_at (Field3)

CERT_KIND (인증제종류)

  • cert_id (id) — int — Primary key — NOT NULL
  • User_id (id2) — int — Foreign key → USER.User_id — NOT NULL
  • Field
  • User_id (id3) — int — Foreign key → USER.User_id — NOT NULL
  • User_id (id4) — int — Foreign key → USER.User_id — NOT NULL

Copy Of USER (CopyOf유저)

  • User_id (id) — int — Primary key — NOT NULL
  • Name (name) — varchar(11)
  • Email (email) — varchar(50)
  • Pass (pass) — varchar(50)
  • Loggedin (loggedin) — bool
  • IsTeacher (isteacher) — bool
  • CreatedAt (created_At) — NOW()

USER (유저)

  • User_id (id) — int — Primary key — NOT NULL
  • Name (name) — varchar(11)
  • Email (email) — varchar(50)
  • Pass (pass) — varchar(50)
  • Loggedin (loggedin) — bool
  • IsTeacher (isteacher) — bool
  • CreatedAt (created_At) — NOW()

authority (권한)

  • auth (Key) — bool — Primary key — NOT NULL

record (기록)

  • cert_id (id) — int — Foreign key → CERT_DETAIL.cert_id — NOT NULL
  • User_id (id2) — int — Foreign key → CERT_DETAIL.User_id — NOT NULL
  • Field