CREATE TABLE ush_user (
user_seq int auto_increment PRIMARY KEY
, user_name varchar (32)
, user_id varchar (32)
, user_pwd varchar (50)
, user_call_num int
, user_email varchar (50)
, user_hobby int
, user_sex int
, user_blog_name varchar (50)
);
CREATE TABLE ush_hobby (
hobby_seq int auto_increment PRIMARY KEY
, hobby_title int
, hobby_major int
);
CREATE TABLE ush_blog_writing (
blog_seq int auto_increment PRIMARY KEY
, blog_reg_date int
, blog_update_date int
, blog_title varchar (50)
, blog_contents varchar (90)
, blog_category_seq int
, blog_user_seq int
);
CREATE TABLE ush_writing_category (
writing_category_seq int auto_increment PRIMARY KEY
, writing_category_hobby int
);
CREATE TABLE ush_comments (
comments_seq int auto_increment PRIMARY KEY
, comments_blog_seq int
, comments_user_seq int
, comments_reg_date int
, comments_comments varchar (200)
);
CREATE TABLE ush_like (
like_seq int auto_increment PRIMARY KEY
, like_user_seq int
, like_blog_seq int
);
CREATE TABLE ush_report (
report_seq int auto_increment PRIMARY KEY
, report_user_seq int
, report_blog_seq int
, report_reason varchar (200)
);
CREATE TABLE ush_product (
product_seq int auto_increment PRIMARY KEY
, product_name varchar (40)
, product_writing varchar (200)
, product_price int
, product_seller int
, product_image varchar (9000)
, product_shopping_category_seq int
);
CREATE TABLE ush_shopping_category (
shopping_category_seq int auto_increment PRIMARY KEY
, shopping_category_name int
);
CREATE TABLE ush_shopping_basket (
shopping_basket_seq int auto_increment PRIMARY KEY
, shopping_basket_user_seq int
, shopping_basket_product_seq int
);
