마음

테이블 (18)

Action_Log (action_log)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Log_Data (log_data) — String
  • Latest_connect (latest_connect) — Date
  • Total_Connection (total_connection) — Int
  • _Type (_type) — String

Anonymous_Qna

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Title (title) — String
  • Content (content) — String
  • Answer (answer) — String

Booking (booking)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • Date (date) — String
  • Time (time) — String

Bookmark (bookmark)

  • id — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Bookmark (bookmark) — bool
  • Content_ID (content_id) — ObjectID[] — 외래 키 → Content.Content_ID — NOT NULL

Comment (comment)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • CompanyBoard_ID (companyboard_id) — ObjectID — 외래 키 → CompanyBoard.CompanyBoard_ID — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Content (content) — String

Company (company)

  • id (objectid) — ObjectID — 기본 키
  • Name (name) — String
  • CompanyCode (companycode) — String
  • Explain (explain) — String

CompanyBoard (companyboard)

  • CompanyBoard_ID (companyboard_id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Type (type) — String or int
  • Title (title) — String
  • Context (context) — String
  • Filename (filename) — String
  • CompanyCode (companycode) — String — FK
  • Like (like) — int
  • Dislike (dislike) — int

Content (content)

  • Content_ID (content_id) — ObjectID — 기본 키 — NOT NULL
  • Title (title) — String
  • Line_Explain (line_explain) — String
  • Explain (explain) — String
  • Type (type) — String — EX) 명상하기 , 마음한줄 등
  • Thumbnail (thumbnail) — String(File)
  • Video_url (video_url) — String
  • Image_file (image_file) — String(File)
  • Music_file (music_file) — String(File)

DailyData (dailydata)

  • DailyData_id (dailydata_id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Datas (datas) — String

Diary (diary)

  • Diary_id (diary_id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Content (content) — String
  • Date (date) — Date

Manager (manager)

  • Manager_ID (manager_id) — ObjectID — 기본 키 — NOT NULL
  • Username (username) — String
  • Phone (phone) — String
  • Name (name) — String
  • PassWord (password) — String

Mind_Color (mind_color)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Color (color) — String

PlayList (playlist)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • ContentList (Contentlist) — ObjectID[] — 외래 키 → Content.Content_ID — NOT NULL

Time_record (time_record)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Time (time) — String
  • Type (type) — String

ToDoList (todolist)

  • ToDoList_id (todolist_id) — ObjectID — 기본 키 — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Date (date) — Date
  • Results (results) — Int[]
  • Active (active) — Bool[]

User (user)

  • User_id (user_id) — ObjectID — 기본 키 — NOT NULL
  • Name (name) — String
  • Username (username) — String
  • PassWord (pw) — String
  • Gender (gender) — String
  • Level (level) — Int
  • Exp (exp) — Int
  • Succeslate (succeslate) — Float
  • Push (push) — Bool
  • PushDate (pushdate) — Bool[]
  • Nickname (nickname) — String
  • Profile (profile) — String(File)
  • CompanyCode (companycode) — String — 외래 키 → Company.id

Vote (vote)

  • id — ObjectID — 기본 키 — NOT NULL
  • Question (question) — String
  • Select (select) — String[]
  • CompanyCode (companycode) — String

Vote_Opinion (vote_opinion)

  • ID (id) — ObjectID — 기본 키 — NOT NULL
  • Vote_id (vote_id) — ObjectID — 외래 키 → Vote.id — NOT NULL
  • User_id (user_id) — ObjectID — 외래 키 → User.User_id — NOT NULL
  • Select_Opinion (select_opinion) — int