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`