Skip to content

Latest commit

 

History

History
53 lines (39 loc) · 1.52 KB

sk_user_documents.md

File metadata and controls

53 lines (39 loc) · 1.52 KB

sk_user_documents

Description

Table Definition
CREATE TABLE `sk_user_documents` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(11) NOT NULL,
  `user_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_from` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Columns

Name Type Default Nullable Extra Definition Children Parents Comment
id int(11) unsigned false auto_increment
document_id int(11) false
user_name varchar(250) false
email varchar(250) false
tel varchar(12) false
request_from varchar(250) true
created timestamp CURRENT_TIMESTAMP true

Constraints

Name Type Definition
PRIMARY PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
PRIMARY PRIMARY KEY (id) USING BTREE

Relations

er


Generated by tbls