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