올투게더 - Edit by H.

테이블 (11)

Article Contents (content_article)

  • Content ID (content_id) — NOT NULL — 기본 키
  • Article ID (article_id) — NOT NULL — 외래 키 → Articles.Article ID — NOT NULL
  • Article Content (content_aricle) — NOT NULL
  • Like Count (likecount_article) — NULL
  • Dislike Count (dislikecount_article) — NULL
  • Author Info Json (author_json) — NOT NULL
  • Author UUID (author_uuid) — NOT NULL
  • Anonymous (anonymous) — NOT NULL

Articles (article)

  • Article ID (article_id) — NOT NULL — 기본 키 — NOT NULL
  • Category ID (category_id) — NOT NULL — 외래 키 → Category.Category ID — NOT NULL
  • Author UUID (author_uuid) — NOT NULL — 외래 키 → User info.User ID — NOT NULL
  • Author Info Json (author_json) — NOT NULL
  • Content ID (content_id) — NOT NULL
  • View Count (view_count) — NOT NULL
  • Anonymous (anonymous) — NOT NULL
  • edited — NOT NULL

Category (category)

  • Category ID (category_id) — NOT NULL — 기본 키 — NOT NULL
  • Category Name (name_category) — NOT NULL
  • Favorite Checked number (count_favorites) — NOT NULL

ChatRT (sessions)

  • Chat ID (chat_id) — NOT NULL — 기본 키 — NOT NULL
  • Session UUID (session_uuid) — NOT NULL
  • Session name (session_nane) — NOT NULL
  • anonymous — NOT NULL
  • chatter UUID list (userUUIDlist) — NOT NULL
  • thumbnailURL — NOT NULL
  • threadUUID — NOT NULL

ChatRT (contents)

  • Chat ID (chat_id) — NOT NULL — 기본 키 — NOT NULL
  • chat ID ref (id_ref) — NOT NULL
  • timestamp — NOT NULL
  • sessionUUID (session_uuid) — NOT NULL
  • chat sender (sender_json) — NOT NULL
  • sender UUID (sender_uuid) — NOT NULL
  • Chat thred ID (chat_thredid) — NOT NULL
  • chat type (chat_type) — NOT NULL
  • chat content text (content_text) — NOT NULL
  • chat content HTML (content_html) — NOT NULL

Class Reviews (reviews_class)

  • Class Review ID (review_id) — NOT NULL — 기본 키
  • Class ID (class_id) — NOT NULL
  • Class Reviewer ID (reviewer_id) — NOT NULL
  • Review Contents (content_review) — NOT NULL
  • Like Count Class Review (likecount_class) — NULL
  • Dislike Count Class Review (dislikecount_class) — NULL

Class Schedule (schedule)

  • User's Schedule ID (schedule_userid) — NOT NULL — 기본 키 — NOT NULL
  • Class ID (class_id) — NOT NULL — 외래 키 → class.Class ID — NOT NULL
  • Class Review ID (review_id) — NOT NULL — 외래 키 → class.Class Review ID
  • Class time (time_class) — NOT NULL

Comments (comment_article)

  • Comment ID (comment_id) — NOT NULL — 기본 키 — NOT NULL
  • Article ID (article_id) — NOT NULL — 외래 키 → Articles.Article ID — NOT NULL
  • Commenter JSON (commenter_json) — NOT NULL
  • Commenter UUID (commenter_uuid) — NOT NULL
  • Comment Content (content_comment) — NOT NULL
  • Anonymous (anonymous) — NOT NULL

School (school_info)

  • School ID (school_id) — NOT NULL — 기본 키 — NOT NULL
  • User ID (user_id) — NOT NULL — 외래 키 → User info.User ID — NOT NULL
  • User's Schedule ID (schedule_userid) — NOT NULL — 외래 키 → User info.User's Schedule ID — NOT NULL
  • Class ID (class_id) — NOT NULL — 외래 키 → User info.Class ID — NOT NULL
  • Class Review ID (review_id) — NOT NULL — 외래 키 → User info.Class Review ID
  • Schol Name (name_school) — NOT NULL
  • School Domain (domain_school) — NOT NULL
  • School UUID (uuid) — NULL
  • School Region (region_school) — NOT NULL

User info (user_info)

  • User ID (user_id) — NOT NULL — 기본 키 — NOT NULL
  • User's Schedule ID (schedule_userid) — NOT NULL — 외래 키 → Class Schedule.User's Schedule ID — NOT NULL
  • Class ID (class_id) — NOT NULL — 외래 키 → Class Schedule.Class ID — NOT NULL
  • Class Review ID (review_id) — NOT NULL — 외래 키 → Class Schedule.Class Review ID
  • Nickname (nickname) — NOT NULL
  • Last Name (lastname) — NOT NULL
  • First Name (firstname) — NOT NULL
  • Email (email) — NOT NULL
  • Phone Number (phonenumber) — NULL
  • School Name (name_school) — NOT NULL
  • Category favorites ID (user_favid) — NULL
  • Private Token (token) — NOT NULL
  • UUID (uuid) — NOT NULL
  • User Preferences (pref) — NOT NULL
  • Trusted Devices (trusted_devices) — NOT NULL
  • Country (user_country) — NOT NULL

class

  • Class ID (class_id) — NOT NULL — 기본 키 — NOT NULL
  • Class Review ID (review_id) — NOT NULL — 외래 키 → Class Reviews.Class Review ID
  • class name (class_name) — NOT NULL
  • School UUID (school_uuid) — NOT NULL
  • class location (class_location) — NULL
  • Class Category (class_category) — NOT NULL
  • Class Prof. (class_prof) — NOT NULL