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