basicMy
Tables (9)
Answer
- postNum — INT — Foreign key → Posts.postNum — NOT NULL
- answerContent — VARCHAR(2000)
- answerDate — DATE
- INDEX — `fk_Member_has_posts_posts1_idx`
Cart
- cartNum — INT — Primary key — NOT NULL
- prodNum — INT — Foreign key → Product.prodNum — NOT NULL
- userid — VARCHAR(45) — Foreign key → Member.userId — NOT NULL
- prodCount — INT
- INDEX — `fk_Product_has_Member_Member1_idx`
- INDEX — `fk_Product_has_Member_Product1_idx`
Category
- catNum — INT — Primary key — NOT NULL
- catName — VARCHAR(45)
Member
- userId — VARCHAR(45) — Primary key — NOT NULL
- userPw — VARCHAR(45)
- userName — VARCHAR(45)
- userPhone — VARCHAR(45)
- userAddr — VARCHAR(45)
- userEmail — VARCHAR(45)
- userRegNum — VARCHAR(45)
Notice
- noticeNum — INT — Primary key — NOT NULL
- userid — VARCHAR(45) — Foreign key → Member.userId — NOT NULL
- noticeTitle — VARCHAR(45)
- noticeContent — VARCHAR(2000)
- noticeDate — DATE
- INDEX — `fk_Notice_Member1_idx`
Order
- orderNum — INT — Primary key — NOT NULL
- userid — VARCHAR(45) — Foreign key → Member.userId — NOT NULL
- oderDate — DATE
- oderPrice — INT
- INDEX — `fk_Order_Member_idx`
OrderDetail
- prodNum — INT — Foreign key → Product.prodNum — NOT NULL
- orderNum — INT — Foreign key → Order.orderNum — NOT NULL
- orderCount — INT
- INDEX — `fk_상품_has_Order_Order1_idx`
- INDEX — `fk_상품_has_Order_상품1_idx`
Posts
- postNum — INT — Primary key — NOT NULL
- userid — VARCHAR(45) — Foreign key → Member.userId — NOT NULL
- postTitle — VARCHAR(45)
- postContent — VARCHAR(2000)
- postDate — DATE
- INDEX — `fk_posts_Member1_idx`
Product
- prodNum — INT — Primary key — NOT NULL
- prodName — VARCHAR(45)
- prodPrice — INT
- prodStock — INT
- catNum — INT — Foreign key → Category.catNum — NOT NULL
- INDEX — `fk_Product_Category1_idx`