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