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