Database Table Field Documentation

afile (Album files: album sub records)

Field Name	Type Size	Display Name	Memo
afid	I(4)	AFID	Album File ID
abid	I(4)	ABID	Album ID
track	I(4)	Track	Track Number
corder	I(4)	Order	Custom order
fid	I(4)	FID	File ID
playcfg	S(2000)	PlayCfg	Play config
a	I(4)	A	Start position
b	I(4)	B	End position
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

album (Album table: define album/playlist)

Field Name	Type Size	Display Name	Memo
abid	I(4)	ABID	Album ID
name	S(300)	Name	Album name
type	I(2)	Type	Album type
title	S(300)	Title	Album Title
corder	I(4)	Order	Custom order
icon	S(300)	Icon	Custom icon number/file
intro	S(1000)	Intro	Introduction of this media file
cnt	I(2)	Cnt	Total count
series	S(30)	Series	Series/Season
cast	S(200)	Cast	Cast/performers
director	S(60)	Director	Director
author	S(200)	Author	Author
vendor	S(60)	Vendor	Vendor/publisher
studio	S(60)	Studio	Studio
region	S(50)	Region	Country or region
lang	S(15)	Lang	Language ID
pubtime	d(8)	Release	Published/released date
pubyear	I(2)	Year	Published/release year
barcode	S(300)	Barcode	Barcode
date1	D(8)	Date1	Date 1
date2	D(8)	Date2	Date 2
date3	D(8)	Date3	Date 3
cat	S(30)	Category	Category
rating	S(50)	Rating	Rating
sr	S(300)	Source	Download source
infosr	S(300)	InfoSource	Info got from
dlang	S(15)	InfoLang	Information data language id
favlevel	i(2)	Fav	Fav level
mark	F(4)	Mark	User mark
memo	S(200)	MyMemo	Custom memo
cflags	S(30)	MyFlags	Custom flags
cfloat	F(8)	MyFloat	Custom float
price	F(8)	Price	Price of item
color	I(4)	Color	Custom color
cover	S(300)	Cover	Cover file
coverfid	I(4)	CoverID	Cover file id
struct	I(4)	Struct	Structure type
ctype	S(50)	ContentType	Content type
scpinfo	S(2000)	ScrapeInfo	Scraper information
scptags	S(1000)	ScrapeTags	Scraped tags
exturls	S(2000)	URLs	External URLs
grpfld	S(50)	GroupBy	Group field
status	S(100)	Status	Status
location	S(300)	Location	Location
dbid	S(300)	DBID	DB ids
smark1	F(4)	SvrMark1
smark2	F(4)	SvrMark2
share	I(2)	Share	Share flags
playcfg	S(500)	PlayCfg	Last play config
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

efile (ExtFile table: cached files)

Field Name	Type Size	Display Name	Memo
efid	I(4)	ExtID	Ext File ID
efname	S(300)	FileName	File name
efsize	i(8)	FileSize	File size
path	S(400)	Path	Store path
title	S(300)	Title	Title
source	S(1000)	Source	Source of file
checksum	S(200)	ChkSum	CheckSum
rsize	i(8)	RealFileSize	Real file size
rchksum	S(200)	RealChkSum	Real CheckSum
refs	S(2000)	RefList	Reference list
flags	I(4)	Flags	Flags
lastuse	D(8)	LastUse	Last use
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

entity (Entity table: actor/director/studio/vendor)

Field Name	Type Size	Display Name	Memo
eid	I(4)	EntID	Entity ID
etype	I(1)	Type	Entity type
name	S(200)	Name	Entity name
role	S(200)	Role	Role
display	S(200)	Display	Display
realname	S(200)	RealName	Real name
altnames	S(500)	AltNames	Other names
gender	i(1)	Gender	Gender
date1	D(8)	Date1	Date 1
date2	D(8)	Date2	Date 2
date3	D(8)	Date3	Date 3
date4	D(8)	Date4	Date 4
favlevel	i(2)	Fav	Fav level
like	I(8)	Like	Like count
mark	F(4)	Mark	User mark
data	S(300)	Data	Data
finance	S(1000)	Finance	Financial data
region	S(50)	Region	Country or region
lang	S(15)	Lang	Language ID
desc	S(2000)	Desc	Description
history	S(3000)	History	History
memo	S(500)	Memo	Memo
pics	S(2000)	Pics	Pictures
logo	S(300)	Logo	Logo
flags	I(4)	Flags	Flags
vflags	I(4)	VisFlags	Visibility flags
url	S(2000)	URL	URL
dbid	S(300)	DBID	DB ids
olang	S(15)	OLang	Original language ID
ovalue	S(200)	OVal	Original value
odesc	S(10000)	ODesc	Original description
smark1	F(4)	SvrMark1
smark2	F(4)	SvrMark2
share	I(2)	Share	Share flags
remind	S(1000)	Remind	Remind config
cflags	S(30)	MyFlags	Custom flags
ctime	D(8)	MyDate	Custom datetime
cstate	S(50)	MyState	Custom status
cfloat	F(8)	MyFloat	Custom float
status	S(100)	Status	Status
flist	S(90000)	FileList	File list
parent	S(300)	Parent	Parent(s)
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time
tags	S(2000)	Tags	Tags
fullpath	C(0)	FullPath	Full path

kv (KV talbe: key/value)

Field Name	Type Size	Display Name	Memo
name	S(100)	Name	Key name
display	S(100)	Display name	Display name
val	S(1000)	Value	Value
flags	I(4)	Flags	Flags

mdir (Directory table: root directories contain media files)

Field Name	Type Size	Display Name	Memo
dirid	I(4)	DirID	Dir ID
corder	I(4)	Order	Custom order
disp	S(200)	Display	Display
dirtype	I(2)	Type	Dir type
fs	S(30)	FS	File system
locid	S(200)	Ident	Location unique ID
path	S(300)	Path	Relative path
addr	S(300)	Address	Address
params	S(2000)
dsize	i(8)	Size	Total size in bytes
dfree	i(8)	Free	Total free in bytes
token	S(2000)
rating	S(50)	Rating	Rating of this dir
memo	S(1000)	Memo	Memo
flags	I(4)
vflags	I(4)	VisFlags	Visibility flags
cflags	S(50)	MyFlags	Custom flags
color	I(4)	Color	Custom color
icon	S(300)	Icon	Custom icon number/file
warnpc	I(4)	WarnPC	Space warning percentage
dirlevel	I(2)	DirLevel	Keep dir level when normalize
state	I(2)	State	Current state
scanmin	I(4)	ScanMin	Rescan interval in minutes
scanlevel	I(2)	ScanLvl	Scan level count
lastscan	D(8)	LastScan	Last scan time
exts	S(2000)	Exts	Accept file extensions
lastconn	D(8)	LastConnect	Last connect time
config	S(2000)	Config	Config
fsize	i(8)	FileSize	Total file size in bytes
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time
tags	S(2000)	Tags	Tags
fullpath	C(0)	FullPath	Full path

mfile (File table: media file details)

Field Name	Type Size	Display Name	Memo
fid	I(4)	FID	File ID
fname	S(300)	FileName	File name
code	S(30)	Code	Published code
cd	I(4)	CD#	CD number/Episode
cast	S(300)	Cast	Cast/performers
director	S(200)	Director	Director
author	S(200)	Author	Author
vendor	S(60)	Vendor	Vendor/publisher
studio	S(60)	Studio	Studio
region	S(50)	Region	Country or region
series	S(30)	Series	Series/Season
cat	S(30)	Category	Category
rating	S(50)	Rating	Rating
intro	S(1000)	Intro	Introduction of this media file
pubtime	d(8)	Release	Published/released date
pubyear	I(2)	Year	Published/release year
favlevel	i(2)	Fav	Fav level
extflags	S(80)	ExtFlags	Extended flags
mark	F(4)	Mark	User mark
memo	S(200)	MyMemo	Custom memo
cflags	S(30)	MyFlags	Custom flags
ctime	D(8)	MyDate	Custom datetime
cstate	S(50)	MyState	Custom status
cfloat	F(8)	MyFloat	Custom float
price	F(8)	Price	Price of item
color	I(4)	Color	Custom color
title	S(300)	Title	Title
state	I(2)	State	Current state
dirid	I(4)	DirID	Dir ID
orgfname	S(300)	OrgName	Original name
path	S(1000)	Path	Path
fsize	i(8)	FileSize	File size
ftime	D(8)	FileTime	File time
crew	S(1000)	Crew
info	S(1000)	Information
misc	S(1000)	Misc information
cs	S(120)	Chksum	Whole checksum
pcs1	S(120)	Chksum1	Checksum 1
pcs2	S(120)	Chksum2	Checksum 2
minfo	S(200)	MediaInfo	Media information
mtype	S(20)	MediaType	Media type
lensec	I(4)	Length	Length in second
x	I(4)	X	Resolution X
y	I(4)	Y	Resolution Y
codec	S(100)	Codec	Codec
brate	S(100)	BitRate	BitRate
mflags	I(4)	MediaFlags	Media flags
lang	S(15)	Language	Original language id
dlang	S(15)	InfoLang	Information data language id
scpinfo	S(2000)	ScrapeInfo	Scraper information
scptags	S(1000)	ScrapeTags	Scraped tags
sr	S(300)	Download	Download source
infosr	S(300)	InfoSource	Info got from
cover	S(300)	Cover	Cover file
coverfid	I(4)	CoverID	Cover file id
preview	S(300)	Preview	Preview file
previewfid	I(4)	PreviewID	Preview file id
ani	S(300)	Ani	Animation file
anifid	I(4)	AniID	Animation file id
nfo	S(300)	NFO	NFO file
sample	S(300)	Sample	Sample file
sub	S(300)	Subtitle	Subtitle file
exturls	S(2000)	URLs	External URLs
dbid	S(300)	DBID	DB ids
barcode	S(300)	Barcode	Barcode
smark1	F(4)	SvrMark1
markcnt1	I(8)	MarkCnt1	Mark count 1
smark2	F(4)	SvrMark2
markcnt2	I(8)	MarkCnt2	Mark count 2
tlike	I(8)	TotalLikeCnt
tplay	I(8)	TotalPlayCnt
share	I(2)	Share	Share flags
playcnt	I(4)	PlayCnt	Play count
playtime	I(4)	PlayTime	Play time
lastplay	D(8)	LastPlay	Last play time
playcfg	S(500)	PlayCfg	Last play config
player	S(1000)	Player	Use player to play
flags	I(4)
vflags	I(4)	VisFlags	Visibility flags
pos1	I(4)	StartPos	Start position in MS
pos2	I(4)	EndPos	End position in MS
parts	S(2000)	Parts	Parts define list
norminfo	S(500)	NormalInfo	Normalize information
prid	I(4)	ParentID	Parent ID
struct	I(4)	Struct	Structure type
ctype	S(50)	ContentType	Content type
flist	S(90000)	FileList	File list
params	S(2000)	Params	Parameters
location	S(300)	Location	Location
status	S(100)	Status	Status
remind	S(1000)	Remind	Remind config
profile	S(1000)	Profile	Profile
config	S(2000)	Config	Config
edition	S(100)	Edition	Edition
format	S(100)	Format	Format(3D/VR)
budget	F(8)	Budget	Budget of item
revenue	F(8)	Revenue	Revenue of item
log	S(1000)	Log	Log information
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time
tags	S(2000)	Tags	Tags
fullpath	C(0)	FullPath	Full path

mtag (Tag table: various kind of tags)

Field Name	Type Size	Display Name	Memo
tagid	I(4)	TagID	Tag ID
tag	S(200)	Tag	Tag content
lang	S(15)	Lang	Language ID
extid	I(4)	ExtID	External ID
usecnt	I(4)	UseCnt	Use count
lastuse	D(8)	LastUse	Last use
flags	I(4)	Flags	Tag flags
favlevel	i(2)	Fav	Fav level
params	S(1000)	Params	Tag parameters
color	I(4)	Color	Custom color
target	S(1000)	Target	Target path
eqid	I(4)	EqualID	Equal tag ID
same	S(2000)	SameTags	Same tags
olang	S(15)	OLang	Original language ID
ovalue	S(200)	OVal	Original value
options	S(200)	Options	Options
tagkind	S(30)	TagKind	Tag kind
vflags	I(4)	VisFlags	Visibility flags
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

script (Script table: define script)

Field Name	Type Size	Display Name	Memo
scrid	I(4)	ScriptID	Script ID
title	S(200)	Title	Script title
scrfile	S(1000)	Filename	Script file name
params	S(1000)	Params	Script calling parameters
version	S(50)	Ver	Script version
reqver	S(50)	ReqVer	Require app version
hash	S(100)	Hash	Script hash code
memo	S(200)	Memo	Memo
copyright	S(300)	Copyright	Copyright information
help	S(2000)	Help	Help information
flags	I(4)	Flags	Flags
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

utag (User tag table: user tags of files/directories/entities)

Field Name	Type Size	Display Name	Memo
utagid	I(4)	UTagID	User Tag ID
tagtype	I(1)	Type	Tag target type
id	I(4)	Which	Tag target ID
tagid	I(4)	TagID	Tag ID
idx	I(4)	Index	Index
addtime	D(8)	Added	Added time
chgtime	D(8)	LastChg	Last modified time

Database Table Fields Documentation