[MySQL] TABLE 구조 잡기

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

);