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