View: nornix_site.vmetadata
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | NO | | 0 | | |
|---|
| Name | varchar(24) | NO | | | | |
|---|
| Value | varchar(255) | NO | | | | |
|---|
| DocumentNo | int(10) unsigned | NO | | 0 | | |
|---|
Information| Algoritm | Updateable |
|---|
| MERGE | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dm | index | PRIMARY,MetaDocUnique | MetaDocUnique | | 6 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | md | ref | PRIMARY | PRIMARY | nornix_site.dm.MetadataNo | 1 | |
| 1 | SIMPLE | me | eq_ref | PRIMARY | PRIMARY | nornix_site.md.ElementNo | 1 | |
CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `nornix_site`.`vmetadata` AS
(select `md`.`No` AS `No`,
`me`.`Name` AS `Name`,
`md`.`Value` AS `Value`,
`dm`.`DocumentNo` AS `DocumentNo`
from (`nornix_site`.`documentmeta` `dm` join (`nornix_site`.`metadata` `md` join
`nornix_system`.`metaelement` `me`)
on (((`dm`.`MetadataNo` = `md`.`No`)
and (`md`.`ElementNo` = `me`.`No`))))
order by `me`.`No`)