node.js

Tables (14)

APIs (Untitled8)

  • apiPk (Key2) — int — Primary key — NOT NULL
  • apiName (Key) — str — Primary key — NOT NULL

ArticleImages (Untitled12)

  • image (Key2) — str — Primary key — NOT NULL
  • articleId (Key3) — Foreign key → Articles.articleId — NOT NULL

Article_Tags (Untitled10)

  • id (Key4) — int — Primary key — NOT NULL
  • articleId (Key3) — int — Foreign key → Articles.articleId — NOT NULL
  • tagName (Key) — str — Foreign key → Tags.tagName — NOT NULL

Articles (Untitled3)

  • articleId (Key3) — Primary key — NOT NULL
  • creater (Users) — str — Foreign key → Users.userId — NOT NULL
  • state (Key5) — int — Foreign key → Status.stateName — NOT NULL
  • permissions (Key2) — list — Foreign key → Permissions.authName — NOT NULL
  • title (Field2) — str
  • tags (Key4) — list — Foreign key → Tags.tagName — NOT NULL
  • text (Field5) — text
  • createAt (Field3) — date
  • updateAt (Field4) — date

ErrorMessages (Untitled11)

  • errorMessagePk (Key) — Primary key — NOT NULL
  • at (Field) — terminal-에러 난곳표시
  • response (Field2) — api reponse(ex.400)
  • detail (Field3) — api reponse(ex.잘못된 input)
  • intro (Field4) — terminal-에러 설명

Permission_APIs (Untitled7)

  • permissionApiPk (Key3) — int — Primary key — NOT NULL
  • authName (Key) — str — Foreign key → Permissions.authName — NOT NULL
  • apiName (Key2) — str — Foreign key → APIs.apiName — NOT NULL

Permission_Articles (Untitled13)

  • permissionArticlePk (Key2) — int — Primary key — NOT NULL
  • authId (Key) — int — Foreign key → Permissions.authName — NOT NULL
  • articleId (Key3) — Foreign key → Articles.articleId — NOT NULL

Permission_Users (Untitled5)

  • permission_userPk (Key3) — int — Primary key — NOT NULL
  • userId (Key2) — str — Foreign key → Users.userId — NOT NULL
  • authName (Key) — int — Foreign key → Permissions.authName — NOT NULL

Permissions (Untitled4)

  • permissionPk (Key2) — Primary key — NOT NULL
  • authName (Key) — str — Primary key — NOT NULL

Status (Untitled2)

  • statePk (Key2) — int — Primary key — NOT NULL
  • stateName (Key) — str — Primary key — NOT NULL

Tags (Untitled9)

  • tagName (Key) — str — Primary key — NOT NULL

UserIPLogs (Untitled6)

  • userIPLogPk (Key) — Primary key — NOT NULL
  • userId (Key2) — str — Foreign key → Users.userId — NOT NULL
  • IP (Field2) — ste
  • api (Field3) — str
  • createdAt (Field) — date

UserInfos (Untitled)

  • userInfoPk (Key2) — Primary key — NOT NULL
  • userId (Key) — str — Foreign key → Users.userId — NOT NULL
  • brithday (Field) — date_only
  • intro (Field2) — text

Users (유저)

  • userPk (Key4) — int — Primary key — NOT NULL
  • userId (Key) — str — Primary key — NOT NULL
  • password (Field2) — str
  • email (Field3) — email
  • state (Key2) — str — Foreign key → Status.stateName — NOT NULL
  • authName (Key3) — list — Foreign key → Permissions.authName — NOT NULL