logit

Tables (17)

Copy Of Copy Of Copy Of Copy Of template3 (reply)

  • Key (reply_id) — Primary key — NOT NULL
  • Key (comment_id) — Foreign key → Copy Of Copy Of Copy Of template3.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (content)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of Copy Of Copy Of template3 (comment)

  • Key (comment_id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Copy Of Copy Of template2.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (content)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of Copy Of Untitled (reply_like)

  • Key (reply_like_id) — Primary key — NOT NULL
  • Key (reply_id) — Foreign key → Copy Of Copy Of Copy Of Copy Of template3.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field2 (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Copy Of template2 (post)

  • Key (post_id) — Primary key — NOT NULL
  • Key (directory_id) — Foreign key → directory.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (thumbnail)
  • Field (wheater) — char(1)
  • Field (mood) — varchar(20)
  • Field (title)
  • Field (content)
  • Field (is_published)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp
  • Field (views)
  • Field (tag)

Copy Of Copy Of template22 (tag)

  • Key (tag_id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Copy Of Copy Of template2.Key — NOT NULL
  • Field (tag_name)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of Copy Of template3 (grass)

  • Key (grass_id) — Primary key — NOT NULL
  • Field (grass_count)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of Untitled (comment_like)

  • Key (comment_like_id) — Primary key — NOT NULL
  • Key (comment_id) — Foreign key → Copy Of Copy Of Copy Of template3.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field2 (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of template (career)

  • Key (career_id) — Primary key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (company_name)
  • Field (position)
  • Field (started_at) — timestamp
  • Field (ended_at) — timestamp
  • Field (information)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of template2 (post_views)

  • Key (post_views_id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Copy Of Copy Of template2.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of template3 (follow)

  • Key (id) — Primary key — NOT NULL
  • member_id (follower) — bitint(20) — Foreign key → member.member_id — NOT NULL
  • member_id (followed) — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Copy Of template4 (my_page_views)

  • Key (id) — Primary key — NOT NULL
  • member_id (viewed) — bitint(20) — Foreign key → member.member_id — NOT NULL
  • member_id (viewer) — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

Untitled (post_like)

  • Key (post_like_id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Copy Of Copy Of template2.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field2 (created_at) — timestamp
  • Field (updated_at) — timestamp

directory

  • Key (directory_id) — Primary key — NOT NULL
  • Key (parent_directory_id) — Foreign key → directory.Key — NOT NULL
  • Key (collection_id) — Foreign key → parent_directory.Key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

member

  • member_id — bitint(20) — Primary key — NOT NULL
  • nickname — NOT NULL
  • email — NOT NULL
  • password — NOT NULL
  • introduction
  • story
  • company
  • learning_method
  • website
  • social_account1
  • social_account2
  • social_account3
  • social_account4
  • location
  • created_at — NOT NULL
  • updated_at — NOT NULL
  • deleted — NOT NULL
  • Field (profile_img)

parent_directory (collection)

  • Key (collection_id) — Primary key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (type) — bit(1)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

technology

  • Key (technology_id) — Primary key — NOT NULL
  • member_id — bitint(20) — Foreign key → member.member_id — NOT NULL
  • Field (technology_name) — varchar(100)
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp

template

  • Key (id) — Primary key — NOT NULL
  • Field (created_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field3 (deleted) — timestamp