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