test

Tables (11)

BOARD

  • BOARD_NUM — INT
  • BOARD_TITLE — VARCHAR(2000) — NOT NULL
  • BOARD_CONTENT — TEXT
  • BOARD_WRITER_ID — VARCHAR(255) — NOT NULL
  • BOARD_REGISTRATION_DATE — DATETIME — NOT NULL

CLAIM

  • CLAIM_NUM — INT
  • CLAIM_BOARD_NUM — INT
  • CLAIM_REPLY_NUM — INT
  • CLAIM_STATUS — VARCHAR(10)
  • CLAIM_TARGET_MEMBER_ID — VARCHAR(255) — NOT NULL
  • CLAIM_REPORTER_ID — VARCHAR(255) — NOT NULL

GOODLIKE

  • LIKE_NUM — INT
  • LIKE_BOARD_NUM — INT
  • LIKE_MEMBER_ID — VARCHAR(255) — NOT NULL

IMAGEFILE

  • FILE_NUM — INT
  • FILE_DIR — VARCHAR(2000)
  • BOARD_ITEM_NUM — INT
  • PRODUCT_ITEM_NUM — INT

MEMBER

  • MEMBER_ID — VARCHAR(255)
  • MEMBER_PASSWORD — VARCHAR(20) — NOT NULL
  • MEMBER_NICKNAME — VARCHAR(20) — NOT NULL
  • MEMBER_NAME — VARCHAR(20) — NOT NULL
  • MEMBER_PROFILE — VARCHAR(100)
  • MEMBER_REGISTRATION_DATE — DATETIME — NOT NULL
  • MEMBER_PHONE — VARCHAR(20)
  • MEMBER_ADDRESS — VARCHAR(100)
  • MEMBER_ROLE — ENUM('USER', 'OWNER', 'BANNED', 'ADMIN')

PAYMENT

  • PAYMENT_NUM — INT
  • PAYMENT_MEMBER_ID — VARCHAR(255)
  • PAYMENT_PRODUCT_NUM — INT
  • PAYMENT_ORDER_NUM — VARCHAR(50) — NOT NULL
  • MERCHANT_UID — VARCHAR(100) — NOT NULL
  • PAYMENT_REGISTRATION_DATE — DATETIME — NOT NULL
  • PAYMENT_PRICE — INT — NOT NULL
  • PAYMENT_STATUS — ENUM('결제완료', '결제취소') — NOT NULL
  • PAYMENT_METHOD — VARCHAR(20) — NOT NULL

PRODUCT

  • PRODUCT_NUM — INT
  • PRODUCT_NAME — VARCHAR(4000) — NOT NULL
  • PRODUCT_PRICE — INT — NOT NULL
  • PRODUCT_DETAILS — VARCHAR(4000)
  • PRODUCT_CNT — INT
  • PRODUCT_ADDRESS — VARCHAR(4000) — NOT NULL
  • PRODUCT_LOCATION — ENUM('바다', '민물') — NOT NULL
  • PRODUCT_CATEGORY — ENUM('낚시배', '낚시터', '낚시카페', '수상') — NOT NULL
  • PRODUCT_SELLER_ID — VARCHAR(255) — NOT NULL

REPLY

  • REPLY_NUM — INT
  • REPLY_CONTENT — VARCHAR(100) — NOT NULL
  • REPLY_WRITER_ID — VARCHAR(255) — NOT NULL
  • REPLY_REGISTRATION_DATE — DATETIME — NOT NULL
  • REPLY_BOARD_NUM — INT — NOT NULL

RESERVATION

  • RESERVATION_NUM — INT
  • RESERVATION_PAYMENT_NUM — INT
  • RESERVATION_REGISTRATION_DATE — DATE — NOT NULL
  • RESERVATION_STATUS — ENUM('예약완료', '예약취소', '사용완료') — NOT NULL

REVIEW

  • REVIEW_NUM — INT
  • REVIEW_CONTENT — VARCHAR(100)
  • REVIEW_PRODUCT_NUM — INT — NOT NULL
  • REVIEW_WRITER_ID — VARCHAR(255)
  • REVIEW_REGISTRATION_DATE — DATETIME — NOT NULL
  • REVIEW_STAR — INT — NOT NULL

WISHLIST

  • WISHLIST_NUM — INT
  • WISHLIST_MEMBER_ID — VARCHAR(255) — NOT NULL
  • WISHLIST_PRODUCT_NUM — INT — NOT NULL