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)