<?php
/*
// OPDS basic gestion (only add entities and relations, not modify)
// Version: 0.1
// Pierre FAUQUE, <pierre@fauque.net>
// Script: 2014, Script->Class: 2019, Gestion: may 2020
// Encoding: UTF-8
// Text editor: GNU/Linux Debian Vi
// File: doc_struct.php (v0.1)
// Role: Documentation, structure of the database
*/
require("init.php");
require("lib_lddocs.php");
?><!DOCTYPE html>
<html>
<head>
<title>Table structures</title>
<meta charset="utf-8">
<link rel="stylesheet" href="opds.css" type="text/css" />
</head>
<body>
<table border="0" width="100%">
<tr>
<td class="cmen">
<?php menu(); ?></td>
<td class="cont">
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<h1>DOC : Table structures</h1>
<pre>
opds_Authors
+-------+-------------+-----------------+------+-----+-------------------+----------------+-----------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+-------+-------------+-----------------+------+-----+-------------------+----------------+-----------------------------+
| idaut | int(11) | NULL | NO | PRI | NULL | auto_increment | Author ID |
| lname | varchar(30) | utf8_general_ci | NO | | NULL | | Author's lastname |
| fname | varchar(30) | utf8_general_ci | NO | | NULL | | Author's firstname |
| bdate | date | NULL | NO | | NULL | | Date of birth |
| ddate | date | NULL | NO | | NULL | | Date of death |
| uri | varchar(80) | utf8_general_ci | NO | | NULL | | URL of the author's page |
| bio | text | utf8_general_ci | NO | | NULL | | Author's brief description |
| upda | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | Date of registration update |
+-------+-------------+-----------------+------+-----+-------------------+----------------+-----------------------------+
opds_Categories;
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| idcat | int(11) | NULL | NO | PRI | NULL | auto_increment | Category ID |
| cat | varchar(30) | utf8_general_ci | NO | | NULL | | Category label |
| descc | tinytext | utf8_general_ci | NO | | NULL | | Brief description |
| active | tinyint(4) | NULL | NO | | 1 | | Displayable in the web catalog (0|1) |
| updc | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | Date of registration update |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
opds_Config;
+--------+-------------+-----------------+------+-----+---------+-------+--------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+--------+-------------+-----------------+------+-----+---------+-------+--------------------------+
| key | varchar(20) | utf8_general_ci | NO | | NULL | | Configuration item label |
| value | varchar(50) | utf8_general_ci | NO | | NULL | | Configuration item value |
| statut | varchar(20) | utf8_general_ci | NO | | NULL | | Necessity of the field |
+--------+-------------+-----------------+------+-----+---------+-------+--------------------------+
opds_Documents;
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| iddoc | int(11) | NULL | NO | PRI | NULL | auto_increment | Document ID |
| title | varchar(60) | utf8_general_ci | NO | | NULL | | Document title |
| descd | text | utf8_general_ci | NO | | NULL | | Document description |
| issued | varchar(10) | utf8_general_ci | NO | | NULL | | Year/Date of issue |
| idscat | int(11) | NULL | NO | | NULL | | Sub-category ID |
| active | int(11) | NULL | NO | | 1 | | Displayable in the web catalog (0|1) |
| updd | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | Date of registration update |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
opds_Keywords;
+---------+-------------+-----------------+------+-----+---------+----------------+---------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+---------+-------------+-----------------+------+-----+---------+----------------+---------------+
| idkw | int(11) | NULL | NO | PRI | NULL | auto_increment | Keyword ID |
| keyword | varchar(30) | utf8_general_ci | NO | | NULL | | Keyword label |
+---------+-------------+-----------------+------+-----+---------+----------------+---------------+
opds_PublishedIn;
+----------+-------------+-----------------+------+-----+-------------------+-------+-----------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+----------+-------------+-----------------+------+-----+-------------------+-------+-----------------------------+
| iddoc | int(11) | NULL | NO | PRI | NULL | | Document ID |
| idtype | int(11) | NULL | NO | PRI | NULL | | Type ID of the ebook |
| lang | varchar(2) | utf8_general_ci | NO | | NULL | | Language of the document |
| filename | varchar(90) | utf8_general_ci | NO | | NULL | | Filename of the ebook |
| thumb | varchar(30) | utf8_general_ci | NO | | NULL | | Filename of the thumbnail |
| descpe | text | utf8_general_ci | NO | | NULL | | Ebook description |
| updpe | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | Date of registration update |
+----------+-------------+-----------------+------+-----+-------------------+-------+-----------------------------+
opds_References;
+-------+---------+-----------+------+-----+---------+-------+-------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+-------+---------+-----------+------+-----+---------+-------+-------------+
| iddoc | int(11) | NULL | NO | PRI | NULL | | Document ID |
| idkw | int(11) | NULL | NO | PRI | NULL | | Keyword ID |
+-------+---------+-----------+------+-----+---------+-------+-------------+
opds_SCategories;
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
| idscat | int(11) | NULL | NO | PRI | NULL | auto_increment | Sub-catgory ID |
| scat | varchar(30) | utf8_general_ci | NO | | NULL | | Sub-category label |
| descsc | tinytext | utf8_general_ci | NO | | NULL | | Brief description |
| active | int(11) | NULL | NO | | 1 | | Displayable in the web catalog (0|1) |
| idcat | int(11) | NULL | NO | | 3 | | Category ID |
| updsc | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | Date of registration update |
+--------+-------------+-----------------+------+-----+-------------------+----------------+--------------------------------------+
opds_Types;
+--------+-------------+-----------------+------+-----+---------+----------------+------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+--------+-------------+-----------------+------+-----+---------+----------------+------------------+
| idtype | int(11) | NULL | NO | PRI | NULL | auto_increment | Ebook type ID |
| type | varchar(15) | utf8_general_ci | NO | | NULL | | Ebook Type label |
| format | varchar(20) | utf8_general_ci | NO | | NULL | | Format to use |
+--------+-------------+-----------------+------+-----+---------+----------------+------------------+
opds_Write;
+-------+---------+-----------+------+-----+---------+-------+-------------+
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
+-------+---------+-----------+------+-----+---------+-------+-------------+
| iddoc | int(11) | NULL | NO | PRI | NULL | | Document ID |
| idaut | int(11) | NULL | NO | PRI | NULL | | Author ID |
+-------+---------+-----------+------+-----+---------+-------+-------------+
</pre>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
</td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
</html>
|