質問編集履歴

1

create 追加

2020/09/04 08:02

投稿

shima3
shima3

スコア5

test CHANGED
File without changes
test CHANGED
@@ -70,6 +70,54 @@
70
70
 
71
71
 
72
72
 
73
+ ### テーブル情報
74
+
75
+
76
+
77
+ ```sql
78
+
79
+ create table tags (
80
+
81
+ id INT AUTO_INCREMENT PRIMARY KEY,
82
+
83
+ product_id int not null,
84
+
85
+ position datetime default null,
86
+
87
+ name varchar(20) default null,
88
+
89
+ note1 text default null,
90
+
91
+ memo text default null,
92
+
93
+ created DATETIME default null,
94
+
95
+ FOREIGN KEY product_key (product_id) REFERENCES products(id)
96
+
97
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
98
+
99
+
100
+
101
+ CREATE TABLE products (
102
+
103
+ id INT AUTO_INCREMENT PRIMARY KEY,
104
+
105
+ field01 varchar(20) default NULL,
106
+
107
+ code VARCHAR(50) NOT NULL,
108
+
109
+ item varchar(255) default null,
110
+
111
+ memo text default null,
112
+
113
+ created DATETIME default null
114
+
115
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
116
+
117
+ ```
118
+
119
+
120
+
73
121
 
74
122
 
75
123
  ### 補足情報