Uniculture

Tables (15)

Copy Of Untitled2 (Purpose)

  • Key (id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (purpose_name)

Untitled (Member)

  • Key (id) — Primary key — NOT NULL
  • Field (age)
  • Field2 (authority)
  • Field3 (born)
  • Field4 (country)
  • Field5 (email)
  • Field (gender)
  • Field2 (introudce)
  • Field3 (nickname)
  • Field4 (password)
  • Field5 (profile)
  • Field (remainCount)

Untitled (ChatRoom)

  • Key (id) — Primary key — NOT NULL
  • Field (latesetMessage)
  • Field2 (latestMessageTime)
  • Field3 (latestMessageType)

Untitled (Friendship)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (from_member_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (to_member_ud) — Foreign key → Untitled.Key — NOT NULL

Untitled (Post)

  • Key (post_id) — Primary key — NOT NULL
  • Key (writer_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (title)
  • Field2 (contnet)
  • Field3 (post_category)
  • Field (post_type)
  • Field2 (post_status)
  • Field3 (title_image)
  • Field (like_count)
  • Field2 (view_count)
  • Field3 (comment_count)

Untitled (PostLike)

  • Key (id) — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (PostTag)

  • Key (id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (tag_name)

Untitled (Comment)

  • Key (id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (writer_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (parent_comment_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (content)
  • Field (is_deleted)

Untitled (Friend_Recommend)

  • Field (from_member_id) — Primary key
  • Field2 (to_member_id) — Primary key
  • Field (created_date)
  • Field (similarity)
  • Field (is_open)

Untitled (Language)

  • Key (id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (langugae_name)
  • Field (type)

Untitled (ChatMessage)

  • Key — Primary key — NOT NULL
  • Field (message)
  • Field (message_type)
  • Field (is_read)
  • Key (id) — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — Foreign key → Untitled.Key — NOT NULL

Untitled (Notification)

    Untitled (FriendRequest)

    • Key (id) — Primary key — NOT NULL
    • Key (sender_id) — Foreign key → Untitled.Key — NOT NULL
    • Key (receiver_id) — Foreign key → Untitled.Key — NOT NULL
    • Field (status)

    Untitled (Participants)

    • Key (member_id) — Foreign key → Untitled.Key — NOT NULL
    • Key (chat_room_id) — Foreign key → Untitled.Key — NOT NULL

    Untitled2 (Hobby)

    • Key (id) — Primary key — NOT NULL
    • Key (member_id) — Foreign key → Untitled.Key — NOT NULL
    • Field (hobby_name)