올투게더 - 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