📄 bookpublisher.html
字号:
<html>
<center>
<table>
<center>
<header align = "center">BOOK</header>
<center>
<table border>
<tr><th>Primary Author</th><th>Title</th><th>ISBN</th><th>PublisherID</th><th>Edition </th><th>Date of Publication</th><th>Price</th><th>Book Description</th>
<tr><td align=center>贾慧星</td><td align=center>天下足球①</td><td align=center>7-301-04815-6</td><td align=center>1000</td><td align=center>edition1</td><td align=center>2005.1.10</td><td align=center>£19.99</td><td align=center>体育类图书</td>
<tr><td align=center>沙朋</td><td align=center>天下足球②</td><td align=center>7-301-04815-7</td><td align=center>1001</td><td align=center>edition1</td><td align=center>2006.1.10</td><td align=center>£19.99</td><td align=center>体育类图书</td>
<tr><td align=center>白鹏</td><td align=center>天下足球③</td><td align=center>7-301-04815-8</td><td align=center>1002</td><td align=center>edition1</td><td align=center>2007.1.10</td><td align=center>£19.99</td><td align=center>体育类图书</td>
<tr><td align=center>郑楠辉</td><td align=center>天下足球④</td><td align=center>7-301-04815-9</td><td align=center>1003</td><td align=center>edition1</td><td align=center>2008.1.10</td><td align=center>£19.99</td><td align=center>体育类图书</td>
</center>
</table>
<br>
Primary Key(s) (PKs): {ISBN}
</br>
<br>
Alternate Key(s) (AKs):{Title}
</br>
<br>
Foreign Key(s) (FKs):{PublisherID}
</br>
<br>
Columns and Domains and The Integrity Constraints:
</br>
<br>
Primary Author : varchar(20)
</br>
<br>
Title : varchar(50)
</br>
<br>
ISBN : varchar(50)
</br>
<br>
PublisherID : varchar(20)
</br>
<br>
Edition : varchar(10)
</br>
<br>
Date of Publication : date
</br>
<br>
Price : NUMERIC(7,2)
</br>
<br>
Book Description : varchar(100)
</br>
<br>
<br>
<center>
<table align="center">
<header align="center">PUBLISHER</header>
<table border>
<tr><th>PublisherID</th><th>Name</th><th>Address</th>
<tr><td align=center>1000</td><td align=center>陕西第一出版社</td><td align=center>西安市沣惠南路31号</td>
<tr><td align=center>1001</td><td align=center>陕西第二出版社</td><td align=center>西安市太白路20号</td>
<tr><td align=center>1002</td><td align=center>陕西第三出版社</td><td align=center>西安市子午路55号</td>
<tr><td align=center>1003</td><td align=center>陕西第四出版社</td><td align=center>西安市含光路66号</td>
</table>
<br>
Primary Key(s) (PKs):{PublisherID}
</br>
<br>
Alternate Key(s) (AKs):{Name Adress}
</br>
<br>
Columns and Domains and The Integrity Constraints:
</br>
<br>
PublisherID : varchar(20)
</br>
<br>
Name: varchar(50)
</br>
<br>
Address :varchar(100)
</br>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -