API Document management tool-database table structure thinking.

API Document management tool-database table structure thinking.

PS: Management tools just to facilitate their own record API basic information, convenient for different developers (App Developer, Restful API Developer) coordination between the work, but also because I am not good at Word document writing, program and design is simple, Daniel, don't squirt!

• API basic Information table
  

  CREATE TABLE api_infor2 (  3apiid uniqueidentifier PRIMARY KEY4, Apicategoryint 5, Apisupport nvarchar ( -) 6, Apiname nvarchar ( $) 7, Apimemo nvarchar ( +) 8, Apiversion nvarchar (5) 9, ApistatusintTen, Apiverbsint One, apisecurityint A, ApiKey nvarchar ( -) -, ApiToken nvarchar ( -) -, Apirequest nvarchar (4000) the, Apiresponse nvarchar (4000) -, Apitags nvarchar ( -) -, Apiresource nvarchar ( -) -, Apiinuserint +, Apiindate datetime -, Apiedituserint +, Apieditdate datetime A)

  
  

• API Classification Information table

1 CREATE TABLE api_category 2  3      int  PRIMARY KEY4     int5     , CategoryName nvarchar (6)     , categoryimage nvarchar (   7 )

• API Access Table

1 CREATE TABLE api_called_infor 2  3      int4     int56      )

• API Management User table
  

  1 CREATE TABLE Api_user2 ( 3UseridintPRIMARY KEY4, LoginName NVARCHAR ( -) 5, UserName NVARCHAR ( -)6, Password NVARCHAR ( -)7 , Status INT8)