올투게더
테이블 (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