adaad

Tables (26)

Message

  • Message_seq — INT — Primary key — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • INDEX — `fk_Message_user1_idx`
  • INDEX — `fk_Message_company_user1_idx`
  • INDEX — `fk_Message_farmer_user1_idx`

QABoard_reply

  • reply_seq — INT — Primary key — NOT NULL
  • user_user_no_seq — INT — Foreign key → user.user_seq — NOT NULL
  • company_user_company_no_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • comment — VARCHAR(255) — NOT NULL
  • qa_board_board_no_seq — INT — Foreign key → qa_board.board_no_seq — NOT NULL
  • INDEX — `fk_comment_user1_idx`
  • INDEX — `fk_comment_company_user1_idx`
  • INDEX — `fk_comment_farmer_user1_idx`
  • INDEX — `fk_QABoard_reply_qa_board1_idx`

auction

  • auction_seq — INT — Primary key — NOT NULL
  • stock_seq — INT — Foreign key → stock.stock_seq — NOT NULL
  • auction_seq (auction_seq2) — INT — Foreign key — NOT NULL
  • count — INT — NOT NULL
  • close_time — DATETIME — NOT NULL
  • farmer_user_farmer_no_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • bid_price — INT
  • INDEX — `fk_jayukMan_farmer_user1_idx`

bid

  • bid_seq — INT — Primary key — NOT NULL
  • price — INT — NOT NULL
  • insertDate — DATETIME
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • company_buy_company_buy_seq — INT — Foreign key → company_buy.company_buy_seq — NOT NULL
  • auction_auction_seq — INT — Foreign key → auction.auction_seq — NOT NULL
  • INDEX — `fk_bid_user1_idx`
  • INDEX — `fk_bid_company_buy1_idx`
  • INDEX — `fk_bid_auction1_idx`

board

  • board_no_seq — INT — Primary key — NOT NULL
  • subject — VARCHAR(45) — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • readnum — VARCHAR(45) — NOT NULL
  • reg_date — DATETIME — NOT NULL
  • file_file_seq — INT — Foreign key → file.file_seq — NOT NULL
  • INDEX — `fk_board_farmer_user_idx`
  • INDEX — `fk_board_company_user1_idx`
  • INDEX — `fk_board_user1_idx`
  • INDEX — `fk_board_file1_idx`

com_wallet

  • wallet_seq — INT — Primary key — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • INDEX — `fk_wallet_company_user1_idx`

company_buy

  • company_buy_seq — INT — Primary key — NOT NULL
  • company_user_company_no_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • stock_stock_seq — INT — Foreign key → stock.stock_seq — NOT NULL
  • INDEX — `fk_company_buy_company_user1_idx`
  • INDEX — `fk_company_buy_stock1_idx`

company_user

  • company_seq — INT — Primary key — NOT NULL
  • company_id — VARCHAR(45) — NOT NULL
  • pw — VARCHAR(45) — NOT NULL
  • com_name — VARCHAR(45) — NOT NULL
  • owner_name — VARCHAR(45) — NOT NULL
  • phone — VARCHAR(45) — NOT NULL
  • adress — VARCHAR(45) — NOT NULL
  • code — VARCHAR(100) — NOT NULL

delivery

  • delivery_seq — INT — Primary key — NOT NULL
  • locate — VARCHAR(100) — NOT NULL
  • destination — VARCHAR(100) — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq
  • company_user_company_no_seq — INT — Foreign key → company_user.company_seq
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq
  • farmer_user_fammer_grade_fammer_grade_seq — INT
  • stock_stock_seq — INT — Foreign key → stock.stock_seq — NOT NULL
  • INDEX — `fk_delivery_user1_idx`
  • INDEX — `fk_delivery_company_user1_idx`
  • INDEX — `fk_delivery_farmer_user1_idx`
  • INDEX — `fk_delivery_stock1_idx`

fammer_grade

  • fammer_grade_seq — INT — Primary key — NOT NULL
  • grade_content — VARCHAR(45) — NOT NULL

farmer_user

  • farmer_seq — INT — Primary key — NOT NULL
  • farmer_id — VARCHAR(45) — NOT NULL
  • fammer_grade_fammer_grade_seq — INT — Foreign key → fammer_grade.fammer_grade_seq — NOT NULL
  • pw — VARCHAR(45) — NOT NULL
  • address — VARCHAR(45) — NOT NULL
  • phone — VARCHAR(45) — NOT NULL
  • code — VARCHAR(45)
  • INDEX — `fk_farmer_user_fammer_grade1_idx`

file

  • file_seq — INT — Primary key — NOT NULL
  • path — VARCHAR(45)
  • name — VARCHAR(45)

like

  • like_seq — INT — Primary key — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • INDEX — `fk_like_company_user1_idx`
  • INDEX — `fk_like_user1_idx`

notice_board

  • board_no_seq — INT — Primary key — NOT NULL
  • subject — VARCHAR(45) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • readnum — VARCHAR(45) — NOT NULL
  • reg_date — DATETIME — NOT NULL
  • file_file_seq — INT — Foreign key → file.file_seq — NOT NULL
  • INDEX — `fk_notice_board_file1_idx`

product

  • product_seq — INT — Primary key — NOT NULL
  • product_name — VARCHAR(45)
  • product_category_product_category_seq — INT — Foreign key → product_category.product_category_seq — NOT NULL
  • product_grade_product_grade_seq — INT — Foreign key → product_grade.product_grade_seq — NOT NULL
  • product_organic_product_organic — INT — Foreign key → product_organic.product_organic — NOT NULL
  • INDEX — `fk_product_product_category1_idx`
  • INDEX — `fk_product_product_grade1_idx`
  • INDEX — `fk_product_product_organic1_idx`

product_category

  • product_category_seq — INT — Primary key — NOT NULL
  • content — VARCHAR(45) — NOT NULL

product_grade

  • product_grade_seq — INT — Primary key — NOT NULL
  • grade — VARCHAR(45) — NOT NULL

product_organic

  • product_organic — INT — Primary key — NOT NULL
  • oranic_status — VARCHAR(45) — NOT NULL

qa_board

  • board_no_seq — INT — Primary key — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • subject — VARCHAR(45) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • readnum — VARCHAR(45) — NOT NULL
  • reg_date — DATETIME — NOT NULL
  • file_file_seq — INT — Foreign key → file.file_seq — NOT NULL
  • INDEX — `fk_board_farmer_user_idx`
  • INDEX — `fk_board_company_user1_idx`
  • INDEX — `fk_board_user1_idx`
  • INDEX — `fk_qa_board_file1_idx`

reply

  • reply_seq — INT — Primary key — NOT NULL
  • user_user_no_seq — INT — Foreign key → user.user_seq — NOT NULL
  • company_user_company_no_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • board_board_seq — INT — Foreign key → board.board_no_seq — NOT NULL
  • comment — VARCHAR(255) — NOT NULL
  • INDEX — `fk_comment_user1_idx`
  • INDEX — `fk_comment_company_user1_idx`
  • INDEX — `fk_comment_farmer_user1_idx`
  • INDEX — `fk_comment_board1_idx`

review

  • review_seq — INT — Primary key — NOT NULL
  • score — INT — NOT NULL
  • content — VARCHAR(505)
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • company_user_company_seq — INT — Foreign key → company_user.company_seq — NOT NULL
  • reviewcol — VARCHAR(45)
  • file_file_seq — INT — Foreign key → file.file_seq — NOT NULL
  • INDEX — `fk_review_farmer_user1_idx`
  • INDEX — `fk_review_user1_idx`
  • INDEX — `fk_review_company_user1_idx`
  • INDEX — `fk_review_file1_idx`

stock

  • stock_seq — INT — Primary key — NOT NULL
  • farmer_user_farmer_no_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • product_product_seq — INT — Foreign key → product.product_seq — NOT NULL
  • INDEX — `fk_stock_farmer_user1_idx`
  • INDEX — `fk_stock_product1_idx`

streaming

  • streaming_seq — INT — Primary key — NOT NULL
  • farmer_user_farmer_seq — INT — Foreign key → farmer_user.farmer_seq — NOT NULL
  • INDEX — `fk_streaming_farmer_user1_idx`

user

  • user_seq — INT — Primary key — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • pw — VARCHAR(45) — NOT NULL
  • address — VARCHAR(45) — NOT NULL
  • phone — VARCHAR(45) — NOT NULL
  • reg_date — DATETIME — NOT NULL
  • up_date — DATETIME — NOT NULL

user_buy

  • buy_seq — INT — Primary key — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq
  • stock_stock_seq — INT — Foreign key → stock.stock_seq — NOT NULL
  • INDEX — `fk_buy_user1_idx`
  • INDEX — `fk_user_buy_stock1_idx`

user_wallet

  • user_wallet_seq — INT — Primary key — NOT NULL
  • user_user_seq — INT — Foreign key → user.user_seq — NOT NULL
  • INDEX — `fk_user_wallet_user1_idx`