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 (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)