2023Chemi
CHEMI ERD -2023 V1
Tables (43)
BANNER (배너)
- id (Key) — INTEGER — Primary key — NOT NULL
- type (Field) — STRING
- title (Field2) — STRING
- contents (Field3) — STRING
- image (Field4) — JSON
- memo (Field5) — TEXT
- createdAt (Field6) — DATE
- updatedAt (Field7) — DATE
- userid (Field8) — INTEGER
CHAT (채팅)
- id (Key) — INTEGER — Primary key — NOT NULL
- targetld (Field4) — INTEGER
- lastmessage (Field) — STRING
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
- chat (Field6) — TINYINT
- meld (Field5) — INTEGER
Communication (소통)
- id (Key) — INTEGER — Primary key — NOT NULL
- type (Field) — STRING
- title (Field2) — TEXT
- contents (Field3) — TEXT
- images (Field4) — JSON
- createdAt (Field5) — DATE
- updatedAt (Field6) — DATE
- userid (Field7) — INTEGER
Folder (폴더)
- id (Key) — INTEGER — Primary key — NOT NULL
- name (Field) — STRING
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
- userid (Field4) — INTEGER
Hashtag (해시태그)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
LiveChat (라이브 채팅)
- id (Key) — INTEGER — Primary key — NOT NULL
- stream (Field) — STRING
- onair (Field2) — TINYINT
- title (Field3) — STRING
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
Mentor (멘토)
- id (Key) — INTEGER — Primary key — NOT NULL
- avatar (Field) — JSON
- introduce (Field2) — TEXT
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- userid (Field5) — INTEGER
Mentorcerti (Untitled)
- id (Key) — INTEGER — Primary key — NOT NULL
- certificate (Field) — JSON
- createdAt (Field2) — DATE
- updatedAt (Field4) — DATE
- userid (Field3) — INTEGER
Mentorexp (경력)
- id (Key) — INTERGER — Primary key — NOT NULL
- title (Field) — STRING
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
- Mentorld (Field4) — INTERGER
Messages (메세지)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- contents (Field2) — STRING
- message (Field3) — STRING
- images (Field4) — JSON
- isOn (Field5) — TINYINT(1)
- type (Field6) — INTEGER
- createdAt (Field7) — DATE
- updatedAt (Field8) — DATE
- chatid (Field9) — INTEGER
- userid (Field10) — INTEGER
- folderid (Field11) — INTEGER
Notification (알림)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- contents (Field2) — STRING
- postinfo (Field3) — STRING
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
- userid (Field6) — INTEGER
Portfolio (포트폴리오)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- image (Field2) — JSON
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- folderid (Field5) — INTEGER
Post (포스트)
- id (Key) — INTEGER — Primary key — NOT NULL
- type (Field) — STRING
- title (Field2) — TEXT
- contents (Field3) — TEXT
- share (Field4) — INTEGER
- like (Field5) — INTEGER
- images (Field6) — JSON
- createdAt (Field7) — DATE
- updatedAt (Field8) — DATE
- userid (Field9) — INTEGER
- memo (Field10) — STRING
PushLogs (푸쉬로그)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- content (Field2) — STRING
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
Questions (질문)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- images (Field2) — JSON
- type (Field3) — TINYINT
- listQuestionN... (Field4) — STRING
- createdAt (Field5) — DATE
- updatedAt (Field6) — DATE
- QuestionsTyp... (Field7) — INTEGER
QuestionsType (질문타입)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- option1 (Field2) — STRING
- option2 (Field18) — STRING
- option1Title (Field3) — STRING
- option2Title (Field4) — STRING
- option1SubTitle (Field5) — STRING
- option2SubTi... (Field6) — STRING
- option1Name (Field7) — STRING
- option2Name (Field8) — STRING
- option1Conte... (Field9) — STRING
- option2Conte... (Field10) — STRING
- option1Color (Field11) — JSON
- option2Color (Field12) — JSON
- opt1images (Field13) — JSON
- opt2images (Field14) — JSON
- option1info (Field15) — STRING
- option2info (Field16) — STRING
- LeftColor (Field17) — JSON
- RightColor (Field19) — JSON
Questions_qs (Untitled2)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- point (Field2) — INTEGER
- type (Field3) — STRING
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
- Questionsid (Field6) — INTEGER
- checked (Field7) — TINYINT
ReComment (추천)
- id (Key) — INTEGER — Primary key — NOT NULL
- contents (Field) — STRING
- images (Field2) — JSON
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- userid (Field5) — INTEGER
School (학교)
- id (Key) — INTEGER — Primary key — NOT NULL
- link (Field) — TEXT
- adres (Field2) — TEXT
- schoolName (Field3) — TEXT
- region (Field4) — TEXT
- totalCount (Field5) — TEXT
- estType (Field6) — TEXT
- seq (Field7) — TEXT
- createdAt (Field8) — DATE
- updatedAt (Field9) — DATE
User (유저)
- id (Key) — INTEGER — Primary key — NOT NULL
- email (Field) — STRING
- password (Field2) — STRING
- salt (Field3) — STRING
- phone (Field4) — STRING
- avatar (Field5) — JSON
- name (Field6) — STRING
- school (Field7) — STRING
- grade (Field8) — TEXT
- myroad (Field9) — STRING
- jeliy (Field10) — INTEGER
- fcmtoken (Field11) — STRING
- ismento (Field12) — TINYINT
- mode (Field13) — TINYINT
- gm (Field14) — INTEGER
- createdAt (Field15) — DATE
- updatedAt (Field16) — DATE
- liveid (Field17) — INTEGER
- roomid (Field18) — INTEGER
- isvalidate (Field19) — TINYINT
UserSearch (유저찾기)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- type (Field2) — STRING
- content (Field3) — STRING
- hashs (Field4) — TEXT
- createdAt (Field5) — DATE
- updatedAt (Field6) — DATE
- userid (Field7) — INTEGER
Version (버전)
- id (Key) — INTEGER — Primary key — NOT NULL
- url (Field) — STRING
- version (Field2) — STRING
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
comments (주석)
- id (Key) — INTEGER — Primary key — NOT NULL
- contents (Field) — STRING
- images (Field2) — JSON
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- recommentid (Field5) — INTEGER
- userid (Field6) — INTEGER
communication_co (소통댓글)
- Communicati... (Field3) — INTEGER — Primary key
- ReCommentid (Field4) — INTEGER — Primary key
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
follow (팔로우)
- Followingld (Field3) — INTEGER — Primary key
- Followingld (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
- chat (Field4) — TINYINT
images (이미지)
- id (Key) — INTEGER — Primary key — NOT NULL
- hash (Field) — STRING
- name (Field2) — STRING
- mime (Field6) — STRING
- url (Field3) — STRING
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
interest (관심사)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- image (Field2) — JSON
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
interestCase (관심계열)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- image (Field2) — JSON
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
interest_post (관심사포스트)
- Interestld (Key) — INTEGER — Primary key — NOT NULL
- Postld (Key2) — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
interest_user (관심사유저)
- interestld (Field3) — INTEGER — Primary key
- Userld (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
interestcase_post (관심계열포스트)
- interestCaseld (Key) — INTEGER — Primary key — NOT NULL
- Postld (Key2) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
interestcase_user (관심계열유저)
- InterestCaseld (Field3) — INTEGER — Primary key
- Userld (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
listQuestions (리스트질문)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- subtitle (Field2) — STRING
- link (Field3) — STRING
- cover (Field4) — JSON
- info (Field5) — STRING
- tag (Field6) — STRING
- mode (Field7) — STRING
- ButtonColor (Field8) — JSON
- Fonts (Field9) — STRING
- ButtonColorR (Field10) — JSON
- GpColor (Field11) — JSON
- image (Field12) — JSON
- startDate (Field13) — DATE
- endDate (Field14) — DATE
- createdAt (Field15) — DATE
- updatedAt (Field16) — DATE
mentor_comment (멘토주석)
- id (Key) — INTEGER — Primary key — NOT NULL
- name (Field) — STRING
- nickname (Field2) — STRING
- contents (Field3) — TEXT
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
- mentorid (Field6) — INTEGER
mentor_hashtag (멘토해쉬태그)
- Hashtagld (Field3) — INTEGER — Primary key
- Memtprld (Field4) — INTEGER — Primary key
- updatedAt (Field2) — DATE
- createdAt (Field) — DATE
mentor_like (멘토좋아요)
- Mentorld (Field3) — INTEGER — Primary key
- Userld (Field4) — INTEGER — Primary key
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
post_comment (포스트코맨드)
- Postld (Field3) — INTEGER — Primary key
- ReCommentld (Field4) — INTEGER — Primary key
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
post_hashtag (포스트해쉬태그)
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
- Hashtagld (Field3) — INTEGER
- Postld (Field4) — INTEGER
post_like (포스트라이크)
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
- Postld (Field3) — INTEGER
- UserId (Field4) — INTEGER
search_list (Untitled3)
- id (Key) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- count (Field2) — INTEGER
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- userid (Field5) — INTEGER
user_bookmark (유저북마크)
- Postld (Field4) — INTEGER — Primary key
- Userld (Field5) — NTEGER — Primary key
- type (Field) — STRING
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
user_folder_reciever (유저폴더리시버)
- id (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
- Field3 — INTEGER
- userid (Field4) — INTEGER
user_folder_send (유저폴더샌드)
- id (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
- folderid (Field3) — INTEGER
- userid (Field4) — INTEGER