File: gestion/doc_struct.php

Recommend this page to a friend!
  Classes of Pierre FAUQUE  >  OPDS PHP Ebook Publisher Class  >  gestion/doc_struct.php  >  Download  
File: gestion/doc_struct.php
Role: Application script
Content type: text/plain
Description: Script of application
Class: OPDS PHP Ebook Publisher Class
Publish and distribute ebooks for download
Author: By
Last change:
Date: 4 months ago
Size: 10,920 bytes
 

Contents

Class file image Download
<?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>&nbsp;</p>
<p>&nbsp;</p>
</body>

</html>

For more information send a message to info at phpclasses dot org.