PHP Classes

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 years 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>