tag

Tables (15)

Article

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • key (category_id) — NOT NULL — Foreign key → Category.key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Key (article_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (create_date) — NOT NULL
  • Field (modify_date) — NOT NULL
  • Field (nickname) — NOT NULL
  • Field (subject) — NOT NULL
  • Field (content) — NOT NULL
  • Field (view_count) — NOT NULL
  • Field (like_count) — NOT NULL
  • Field (dislike_count) — NOT NULL
  • Field (article_crime) — NULL

Category

  • key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL

Copy Of Category (Servey)

  • key (id) — NOT NULL — Primary key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (subject) — NOT NULL
  • Field (number) — NOT NULL

Copy Of Copy Of Article (FileUpload)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (article_id) — NOT NULL — Foreign key → Article.Key — NOT NULL
  • Key (comment_id) — NOT NULL — Foreign key → Copy Of Copy Of Copy Of Article.Key — NOT NULL
  • key (advertise_id) — NOT NULL — Foreign key → Copy Of Copy Of Category.key — NOT NULL
  • Field (origFileName) — NOT NULL
  • Field (filePath) — NOT NULL
  • Field (fileSize) — NOT NULL

Copy Of Copy Of Category (Advertise)

  • key (id) — NOT NULL — Primary key — NOT NULL
  • key (company_id) — NOT NULL — Foreign key → Copy Of Copy Of Copy Of Category.key — NOT NULL
  • Field (content) — NOT NULL

Copy Of Copy Of Category2 (Chat)

  • key (id) — NOT NULL — Primary key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (talk_date) — NOT NULL
  • Field (context) — NOT NULL

Copy Of Copy Of Copy Of Article (Comment)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (article_id) — NOT NULL — Foreign key → Article.Key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → Article.Key — NOT NULL
  • Field (content) — NOT NULL
  • Field (view_count) — NOT NULL
  • Field2 (like_count) — NOT NULL
  • Field (dislike_count) — NOT NULL
  • Field (comment_crime) — NULL

Copy Of Copy Of Copy Of Category (Company)

  • key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (memo) — NULL

Copy Of Copy Of Copy Of Category2 (Crime)

  • Key — NOT NULL — Primary key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field2 (content) — NOT NULL

Copy Of Copy Of User (ManagerMember)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Key (role_id) — NOT NULL — Foreign key → Role.Key — NOT NULL
  • Field3 (access_token) — NOT NULL

Copy Of User (Oauthid)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field3 (access_token) — NOT NULL

Role

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (version) — NOT NULL
  • Field (authority) — NOT NULL

Tag (ArticleTag)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • key (article_id) — NOT NULL — Foreign key → Article.key — NOT NULL
  • Field (content) — NOT NULL

User (Member)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (article_id) — NOT NULL — Foreign key → Copy Of Copy Of Copy Of Article.Key — NOT NULL
  • Key (oauth_id) — NOT NULL — Foreign key → Copy Of User.Key — NOT NULL
  • Field (username) — NOT NULL
  • Field2 (password) — NOT NULL
  • Field (nickname) — NOT NULL
  • Field3 (date_created) — NOT NULL
  • Field (date_withdraw) — NULL
  • Field (member_crime) — NULL

User_role (UserRole)

  • Key (role_id) — NOT NULL — Foreign key → Role.Key — NOT NULL
  • Key (member_id) — NOT NULL — Foreign key → User.Key — NOT NULL