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`