test
Tables (16)
AdminProduct
- adminProductSeq — NOT — Primary key — NOT NULL
- adminProductName — NOT — NOT NULL
- adminProductPrice — NOT — NOT NULL
- adminProductInfo — NOT — NOT NULL
- adminProductImg — NOT — NOT NULL
- userId2 — NOT — NOT NULL
AgricultureJouranl
- 농사일지시퀀스 — NOT — Primary key — NOT NULL
- userId — NOT — NOT NULL
- agricultureDate — NOT — NOT NULL
- agricultureContents — NOT — NOT NULL
- agricultureStartDate — VARCHAR(255)
- agricultureEndDate — VARCHAR(255)
- agricultureTitle — NOT — NOT NULL
- agricultureImg — VARCHAR(255)
Chatting
- Key — VARCHAR(255) — Primary key — NOT NULL
Comment
- Key — VARCHAR(255) — Primary key — NOT NULL
Hashtag
- hashTagSeq — NOT — Primary key — NOT NULL
- hashTagName — NOT — NOT NULL
KnowhowShareBoard
- Key — VARCHAR(255) — Primary key — NOT NULL
- userId — NOT — NOT NULL
Message
- Key — VARCHAR(255) — Primary key — NOT NULL
NoticeBoard
- noticeBoardSeq — NOT — Primary key — NOT NULL
- userId — NOT — NOT NULL
- noticeBoardTitle — NOT — NOT NULL
- noticeBoardContents — NOT — NOT NULL
- noticeBoardDate — SYSDATE
Order
- orderSeq — NOT — Primary key — NOT NULL
- userId — NOT — NOT NULL
- adminProductSeq — NOT — NOT NULL
PersonalProduct
- personalProductSeq — NOT — Primary key — NOT NULL
- productName — NOT — NOT NULL
- personalProductPrice — NOT — NOT NULL
- userAddress — NOT — NOT NULL
- personalProductInfo — NOT — NOT NULL
- personalProductImg — NOT — NOT NULL
- userId2 — NOT — NOT NULL
RealTimeNotice
- Key — VARCHAR(255) — Primary key — NOT NULL
Reservation
- Key — VARCHAR(255) — Primary key — NOT NULL
SNSBoardTable
- SNSBoardSeq — NOT — Primary key — NOT NULL
- userId — NOT — NOT NULL
- snsDate — SYSDATE — NOT NULL
- snsImage — NOT — NOT NULL
- snsLike — VARCHAR(255)
- snsContents — NOT — NOT NULL
SNSHashTag
- snsHashTagSeq — NOT — Primary key — NOT NULL
- hashTagSeq — NOT — NOT NULL
- SNSBoardSeq — NOT — NOT NULL
Users
- userId — NOT — Primary key — NOT NULL
- password — NOT — NOT NULL
- userEmail — NOT — NOT NULL
- userPhone — NOT — NOT NULL
- userAddress — VARCHAR(255)
- userRole — ADMIN
- USER — NULL
- userName — NOT — NOT NULL
- userBirthday — NOT — NOT NULL
weekendFarm
- Key — VARCHAR(255) — Primary key — NOT NULL