gijangAjumma

Tables (11)

Gijang_AnnouncementBoard (gijang_AnnouncementBoard)

  • gijang_AnnouncementBoard_Idx — number — Primary key — NOT NULL
  • gijang_AnnouncementBoard_Title — varchar2(1000)
  • gijang_AnnouncementBoard_Writer — varchar2(500) — Foreign key → Gijang_Member.Gijang_Member_Idx — NOT NULL
  • gijang_AnnouncementBoard_Content — varchar2(4000)
  • gijang_AnnouncementBoard_Wdate — date

Gijang_Member

  • Gijang_Member_Idx (gijang_Member_Idx) — number — Primary key — NOT NULL
  • Gijang_Member_UserName (gijang_Member_UserName) — varchar2(500)
  • Gijang_Member_UserId (gijang_Member_UserId) — varchar2(500)
  • Gijang_Member_Userpw (gijang_Member_Userpw) — varchar2(4000)
  • Gijang_Member_Salt (gijang_Member_Salt) — varchar2(1000)
  • Gijang_Member_Email (gijang_Member_Email) — varchar2(500)
  • Gijang_Member_Pnum (gijang_Member_Pnum) — varchar2(300)
  • Gijang_Member_Birth (gijang_Member_Birth) — varchar2(500)
  • Gijang_Member_Zipcode (gijang_Member_ZipCode) — varchar2(500)
  • Gijang_Member_Address (gijang_Member_Address) — varchar2(500)
  • Gijang_Member_DetailAddress (gijang_Member_DetailAddress) — varchar2(500)
  • Gijang_Member_ExtraAddress (gijang_Member_ExtraAddress) — varchar2(500)
  • Gijang_Member_IsAdmin (gijang_Member_IsAdmin) — varchar2(10)

Gijang_OrderList (gijang_OrderList)

  • gijang_OrderList_Idx — number — Primary key — NOT NULL
  • gijang_OrderList_SaleBoardIdx — number
  • gijang_OrderList_UserId (gijang_Member_Idx) — varchar2(500) — Foreign key → Gijang_Member.Gijang_Member_Idx — NOT NULL
  • gijang_OrderList_UserName — varchar2(500)
  • gijang_OrderList_Pnum — varchar2(500)
  • gijang_OrderList_ProductName — varchar2(1000)
  • gijang_OrderList_ProductDetailName — varchar2(1000)
  • gijang_OrderList_ProductDetailCount — number
  • gijang_OrderList_ProductDetailPrice — varchar2(500)
  • gijang_OrderList_OrderDate — date
  • gijang_OrderList_TotalPrice — varchar2(500)
  • gijang_OrderList_Zipcode — varchar2(500)
  • gijang_OrderList_Address — varchar2(500)
  • gijang_OrderList_DetailAddress — varchar2(500)
  • gijang_OrderList_ExtarAddress (gijang_OrderList_ExtraAddress) — varchar2(500)
  • gijang_OrderList_PaymentStatus — varchar2(10)

Gijang_QnABoard (gijang_QnABoard)

  • gijang_QnABoard_Idx — number — Primary key — NOT NULL
  • gijang_Member_UserId — varchar2(500) — Foreign key → Gijang_Member.Gijang_Member_Idx — NOT NULL
  • gijang_QnABoard_Title — varchar2(1000)
  • gijang_QnABoard_Content — varchar2(4000)
  • gijang_QnABoard_Password — number
  • gijang_QnABoard_Wdate — date
  • gijang_QnABoard_IsAnswer — varchar2(2)

Gijang_QnAComment (gijang_QnAComment)

  • gijang_QnAComment_Idx — number — Primary key — NOT NULL
  • gijang_QnAComment_QnABoardIdx — number
  • gijang_QnAComment_Writer — varchar2(500)
  • gijang_QnAComment_Content — varchar2(3000)
  • gijang_QnAComment_Wdate — date
  • gijang_QnABoard_Idx — number — Foreign key → Gijang_QnABoard.gijang_QnABoard_Idx — NOT NULL

Gijang_ReviewBoard (gijang_ReviewBoard)

  • gijang_ReviewBoard_Idx — number — Primary key — NOT NULL
  • gijang_ReviewBoad_OrderListIdx (gijang_OrderList_Idx) — number — Foreign key → Gijang_OrderList.gijang_OrderList_Idx — NOT NULL
  • gijang_ReviewBoard_Writer — varchar2(500)
  • gijang_ReviewBoard_Title — varchar2(500)
  • gijang_ReviewBoard_Content — varchar2(4000)
  • gijang_ReviewBoard_Grade — number
  • gijang_ReviewBoard_Wdate — date
  • gijang_ReviewBoard_FileName — varchar2(1000)
  • gijang_ReviewBoard_IsDelete — varchar2(2)

Gijang_ReviewComment (gijang_ReviewComment)

  • gijang_ReviewComment_Idx — number — Primary key — NOT NULL
  • gijang_ReviewComment_ReviewBoardIdx — number — Foreign key → Gijang_ReviewBoard.gijang_ReviewBoard_Idx — NOT NULL
  • gijang_ReviewComment_Writer — varchar2(1000)
  • gijang_ReviewComment_Content — varchar2(4000)
  • gijang_ReviewComment_Wdate — date

Gijang_SaleBoard (gijang_SaleBoard)

  • gijang_Saleboard_Idx — number — Primary key — NOT NULL
  • gijang_Saleboard_ImgFileName — varchar2(1000)
  • gijang_Saleboard_Title — varchar2(500)
  • gijang_Saleboard_Price — varhcar2(500)
  • gijang_Saleboard_IsSold — varchar2(2)
  • gijang_Saleboard_Type — varchar2(500)

Gijang_WishList (gijang_WishList)

  • gijang_WishList_Idx — number — Primary key — NOT NULL
  • gijang_WishList_SaleBoardIdx (gijang_Saleboard_Idx) — number — Foreign key → Gijang_SaleBoard.gijang_Saleboard_Idx — NOT NULL
  • gijang_WishList_UserId — varchar2(500)

ProductDetailIndividual

  • ProductDetailIndividual_Idx — number — Primary key — NOT NULL
  • ProductDetailIndividual_SaleBoard_Idx (gijang_Saleboard_Idx) — number — Foreign key → Gijang_SaleBoard.gijang_Saleboard_Idx — NOT NULL
  • ProductDetailIndividual_ImgFileName1 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName2 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName3 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName4 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName5 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName6 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName7 — varchar2(1000)
  • ProductDetailIndividual_ImgFileName8 — varchar2(1000)

ProductDetail_Common (ProductDetail)

  • productDetail_Idx (Key) — number — Primary key — NOT NULL
  • productDetail_ImgFileName1 (Field) — varchar2(1000)
  • productDetail_ImgFileName2 (Field2) — varchar2(1000)
  • productDetail_ImgFileName3 (Field3) — varchar2(1000)
  • productDetail_ImgFileName4 (Field4) — varchar2(1000)
  • productDetail_ImgFileName5 (Field5) — varchar2(1000)
  • productDetail_ImgFileName6 (Field6) — varchar2(1000)
  • productDetail_ImgFileName7 (Field7) — varchar2(1000)
  • productDetail_ImgFileName8 (Field8) — varchar2(1000)
  • productDetail_ImgFileName9 (Field9) — varchar2(1000)
  • productDetail_ImgFileName10 (Field10) — varchar2(1000)
  • productDetail_ImgFileName11 (Field11) — varchar2(1000)
  • productDetail_ImgFileName12 (Field12) — varchar2(1000)
  • productDetail_ImgFileName13 (Field13) — varchar2(1000)
  • productDetail_ImgFileName14 (Field14) — varchar2(1000)
  • productDetail_ImgFileName15 (Field15) — varchar2(1000)
  • productDetail_ImgFileName16 (Field16) — varchar2(1000)
  • productDetail_ImgFileName17 (Field17) — varchar2(1000)
  • productDetail_ImgFileName18 (Field18) — varchar2(1000)
  • productDetail_ImgFileName19 (Field19) — varchar2(1000)
  • productDetail_ImgFileName20 (Field20) — varchar2(1000)
  • productDetail_ImgFileName21 (Field21) — varchar2(1000)
  • productDetail_ImgFileName22 (Field22) — varchar2(1000)
  • productDetail_ImgFileName23 (Field23) — varchar2(1000)
  • productDetail_ImgFileName24 (Field24) — varchar2(1000)
  • productDetail_ImgFileName25 (Field25) — varchar2(1000)
  • productDetail_ImgFileName26 (Field26) — varchar2(1000)
  • productDetail_ImgFileName27 (Field27) — varchar2(1000)