home / kengdb

kengdb

Database actions Database actions
  • Create a table

Custom SQL query

Tables schema

folderTb

id, user_id, folder, parent_folder_id, system_key, undeletable

26 rows

friendTb

id, user_id, friend_id, status, created_at, updated_at

4 rows

linkTb

id, from_note_id, to_note_id, user_id, created_at

4 rows

noteShareTb

id, note_id, from_user_id, to_user_id, permission, created_at, updated_at, folder_key, dismissed, position

1 row

noteTb

id, user_id, content, tags, created_at, updated_at, enable, pinned, folder_id, comment, position, visibility

93 rows

oauthAccountTb

id, user_id, provider, provider_user_id, email, created

0 rows

otherNoteTb

id, source, method, user_id

8 rows

sessionTb

id, user_id, token, expires, created, updated

38 rows

shareLinkTb

token, note_id, from_user_id, expires_at, view_count, created_at

0 rows

smsCodeTb

phone, code, expires, last_sent

2 rows

sqlite_sequence

name, seq

10 rows

teamFolderTb

id, team_id, name, created_at

3 rows

teamMemberTb

id, team_id, user_id, role, joined_at

30 rows

teamNoteTb

id, team_id, author_id, content, tags, created_at, updated_at, enable, pinned, comment, folder_id, locked_by, position

32 rows

teamTb

id, teamName, ownerUsr_id, create_at, password

5 rows

userIntegrationTb

id, user_id, source, token, meta_json, created_at, updated_at

1 row

userLvlTb

id, level, levelName, limitNote, limitLucy, canuseAPI

5 rows

userTb

id, username, nickname, password, level_id, phone, phone_bind, email, email_bind, created_at, enable, username_locked, secre, persona, disposition, api_key, github_id

5 rows

Powered by Datasette