4,395
edits
mNo edit summary |
|||
| Line 25: | Line 25: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| NULL | | NULL | ||
| Line 49: | Line 49: | ||
| login | | login | ||
| varchar(50) | | varchar(50) | ||
| | | NO | ||
| | | UNI | ||
| | | | ||
| | | | ||
| Line 62: | Line 62: | ||
| | | | ||
| login password of member | | login password of member | ||
|- | |||
| fk_adherent_type | |||
| int(11) | |||
| NO | |||
| MUL | |||
| | |||
| | |||
| ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid) | |||
|- | |- | ||
| morphy | | morphy | ||
| varchar(3) | | varchar(3) | ||
| | | NO | ||
| | | | ||
| | | | ||
| Line 77: | Line 85: | ||
| | | | ||
| | | | ||
| | | society | ||
|- | |- | ||
| fk_soc | | fk_soc | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| | | UNI | ||
| | | | ||
| | | | ||
| Line 169: | Line 177: | ||
| statut | | statut | ||
| smallint | | smallint | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| Line 177: | Line 185: | ||
| public | | public | ||
| smallint | | smallint | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| Line 197: | Line 205: | ||
| | | | ||
| | | | ||
| | | comentary | ||
|- | |- | ||
| tms | | tms | ||
| timestamp | | timestamp | ||
| | | NO | ||
| | | | ||
| CURRENT_TIMESTAMP | | CURRENT_TIMESTAMP | ||