올투게더

테이블 (10)

Article Contents (content_article)

  • Content ID (content_id) — NOT NULL — 기본 키
  • Article ID (article_id2) — NOT NULL — 외래 키 → Articles.Article ID — NOT NULL
  • Article ID (article_id) — NOT NULL — 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

Articles (article)

  • Article ID (article_id) — NOT NULL — 기본 키 — NOT NULL
  • User ID (user_id) — NOT NULL — 외래 키 → User info.User ID — NOT NULL
  • Author Info Json (author_json) — NOT NULL
  • Content ID (content_id) — NOT NULL
  • Category ID (category_id) — NOT NULL
  • View Count (view_count) — NOT NULL
  • Comment ID (comment_id) — NOT NULL

Category (category)

  • Category ID (category_id) — NOT NULL — 기본 키 — NOT NULL
  • Article ID (article_id) — NOT NULL — 외래 키 → Articles.Article ID — 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
  • Chat UUID (uuid) — NOT NULL
  • chatter name (chat_name) — NOT NULL
  • anonymous — NOT NULL
  • chatter UUID list (userUUIDlist) — NOT NULL
  • thumbnailURL — NOT NULL
  • threadUUID — NOT NULL

ChatRT (content)

  • Chat ID (chat_id) — NOT NULL — 기본 키 — NOT NULL
  • chat ID ref (id_ref)
  • timestamp
  • sessionUUID
  • chat sender (sender)
  • Chat thred ID (chat_thredid)
  • chat type (chat_type)
  • chat context text (contextText)
  • chat content HTML (contentHTML)

Class Details (detail_class)

  • Class Schedule ID (schedule_id) — NOT NULL — 기본 키 — NOT NULL
  • Class Schedule ID (schedule_id2) — NOT NULL — 외래 키 → Class Schedule.Class Schedule ID — NOT NULL
  • Class Review ID (review_id) — NOT NULL
  • Class Review Writer (reviewer_id) — NOT NULL
  • Review Contents (review_class) — NOT NULL
  • Like Count Class Review (likecount_class) — NULL
  • Dislike Count Class Review (dislikecount_class) — NULL

Class Schedule (schedule)

  • Class Schedule ID (schedule_id) — NOT NULL — 기본 키 — NOT NULL
  • User ID (user_id) — NOT NULL — 외래 키 → User info.User ID — NOT NULL
  • Schedule Name (schedule_name) — NOT NULL
  • School UUID (school_uuid) — NOT NULL
  • Class time (time_class) — NOT NULL
  • Class Location (location_class) — NULL
  • Class Subject(category) (category_class) — NOT NULL
  • Class Professor (prof_class) — NULL

Comments (comment)

  • Comment ID (comment_id) — NOT NULL — 기본 키 — NOT NULL
  • Article ID (article_id) — NOT NULL — 기본 키
  • Article ID (article_id2) — NOT NULL — 외래 키 → Articles.Article ID — NOT NULL
  • Comenter ID (commenter_id) — NOT NULL
  • Commenter Name (commenter_name) — NOT NULL
  • Comment Content (content_comment) — 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
  • Schol Name (name_school) — NOT NULL
  • School Domain (domain_school) — NOT NULL
  • School Address (address_school) — NOT NULL
  • School Type (type_school) — NULL
  • School UUID (uuid) — NOT NULL
  • School Location (location) — NOT NULL

User info (user_info)

  • User ID (user_id) — NOT NULL — 기본 키 — NOT NULL
  • 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
  • Class Schedule ID (schedule_id) — NOT NULL
  • Address (address_user) — NOT NULL
  • Category favorites ID (user_favid) — NULL
  • Private Token (token) — NOT NULL
  • UUID (uuid) — NOT NULL