TRADEUP
Tables (22)
CATEGORY (Untitled4)
- category_idx (Key) — INT — Primary key — NOT NULL
- category_name (Field) — VARCHAR(100)
CHAT_MESSAGE (Untitled16)
- room_id (Key) — VARCHAR(50) — Foreign key → CHAT_ROOM_LIST.room_id — NOT NULL
- sender_id (Field) — VARCHAR(16)
- receiver_id (Field2) — VARCHAR(16)
- message (Field3) — TEXT
- type (Field4) — VARCHAR(10)
- message_target (Field5) — VARCHAR(11)
- send_time (Field6) — DATETIME
CHAT_ROOM_LIST (Untitled15)
- room_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- user_id (Field) — VARCHAR(16)
- status (Field2) — VARCHAR(16)
COMMITION_ACCOUNT (Untitled19)
- account_idx (Key) — INT — Primary key — NOT NULL
- owner_bank (Field) — VARCHAR(30)
- owner_acc (Field2) — VARCHAR(20)
- commissions (Field4) — VARCHAR(20)
DEPOSIT (Untitled20)
- deposit_idx (Key) — INT — Primary key — NOT NULL
- deposit_bank (Field) — VARCHAR(30)
- deposit_acc (Field2) — VARCHAR(20)
- owner_bank (Field3) — VARCHAR(30)
- owner_acc (Field4) — VARCHAR(20)
- product_price (Field5) — VARCHAR(10)
- member_id (Field6) — VARCHAR(15)
- member_name (Field7) — VARCHAR(10)
- deposit_date (Field8) — DATETIME
- product_num (Field9) — INT
- merchant_uid (Field10) — VARCHAR(30)
EXITED_FEEDBACK (Untitled18)
- exid_feedback_idx (Key) — INT — Primary key — NOT NULL
- exid_feedback (Field) — TEXT
- exid_feedback_tip (Field2) — TEXT
FAVORITE (Untitled3)
- favorite_idx (Key) — INT — Primary key — NOT NULL
- member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- product_num (Key2) — INT — Foreign key → PRODUCT.product_num — NOT NULL
FINTECH_USER_INFO (Untitled7)
- member_id (Key2) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- access_token (Field) — VARCHAR(500)
- user_seq_no (Field2) — VARCHAR(10)
- Field3
MEMBER (Untitled)
- member_num (Key) — INT — Primary key — NOT NULL
- member_id (Key2) — VARCHAR(15) — Primary key — NOT NULL
- member_name — VARCHAR(15)
- member_nick_name (Field) — VARCHAR(100)
- member_passwd (Field3) — VARCHAR(100)
- member_e_mail (Field4) — VARCHAR(100)
- member_e_mail1 (Field5) — VARCHAR(100)
- member_e_mail2 (Field6) — VARCHAR(100)
- member_insert_date (Field7) — DATETIME
- member_phone_num (Field8) — VARCHAR(100)
- member_birth (Field9) — VARCHAR(100)
- kakao_id (Field10) — VARCHAR(100)
- naver_id (Field11) — VARCHAR(100)
- member_state (Field12) — VARCHAR(100)
- exid_date (Field13) — DATETIME
- exid_feedback_idx (Field14) — INT
- exid_etc_feedack (Field15) — TEXT
- member_profile_img (Field16) — TEXT
MY_ACCOUNT (Untitled6)
- account_idx (Key) — INT — Primary key — NOT NULL
- member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- account_num (Field) — VARCHAR(100)
- account_bank (Field2) — VARACHAR(20)
- account_main (Field3) — TINYINT
- account_holder_name (Field4) — VARCHAR(15)
MY_ADDRESS (Untitled10)
- address_idx (Key) — INT — Primary key — NOT NULL
- member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- recipient_name (Field) — VARCHAR(10)
- recipient_phone_num (Field2) — VARCHAR(20)
- address1 (Field3) — VARCHAR(100)
- address2 (Field4) — VARCHAR(100)
- address_name (Field5) — VARCHAR(20)
- address_main (Field6) — TINYINT(1)
- postcode (Field7) — VARCHAR(10)
OFTEN_QUESTION (Untitled17)
- often_qna_num (Key) — INT — Primary key — NOT NULL
- qna_content (Field) — TEXT
- qna_answer (Field2) — TEXT
- qna_filter (Field3) — VARCHAR(3)
PRODUCT (Untitled2)
- product_num (Key) — INT — Primary key — NOT NULL
- member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- category_idx (Key3) — INT — Foreign key → CATEGORY.category_idx — NOT NULL
- product_name (Field) — VARCHAR(100)
- product_price (Field2) — VARCHAR(15)
- product_info (Field3) — TEXT
- product_release (Field4) — DATETIME
- product_main_img (Field5) — VARCHAR(10)
- Trading_method (Field6) — VARCHAR(10)
- product_status (Field7) — VARCHAR(10)
- delivery_method (Field8)
PRODUCT_IMG (Untitled5)
- product_image_num (Key) — INT — Primary key — NOT NULL
- product_num (Key2) — INT — Foreign key → PRODUCT.product_num — NOT NULL
- product_image (Field) — TEXT
QUESTION (Untitled11)
- qna_num (Key) — INT — Primary key — NOT NULL
- member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
- qna_category_detail_num (Key2) — INT — Foreign key → QUESTION_CATEGORY_DETAIL.qna_category_detail_num — NOT NULL
- qna_content (Field) — TEXT
- qna_answer (Field2) — TEXT
- qna_is_answer (Field3) — VARCHAR(2)
- qna_date (Field4) — VARCHAR(30)
QUESTION_CATEGORY (Untitled14)
- qna_category_num (Key) — INT — Primary key — NOT NULL
- qna_category_name (Field) — VARCHAR(100)
QUESTION_CATEGORY_DETAIL (Untitled12)
- qna_category_detail_num (Key) — INT — Primary key — NOT NULL
- qna_category_num (Key2) — INT — Foreign key → QUESTION_CATEGORY.qna_category_num — NOT NULL
- qna_category_detail_name (Field) — VARCHAR(100)
QUESTION_IMG (Untitled13)
- qna_num (Key) — INT — Foreign key → QUESTION.qna_num — NOT NULL
- qna_image_name (Field) — VARCHAR(100)
- qna_image_real_file (Field2) — VARCHAR(100)
REPORT (Untitled8)
- report_idx (Key) — INT — Primary key — NOT NULL
- report_member_num (Key2) — INT — Foreign key → MEMBER.member_num — NOT NULL
- report_product_num (Key3) — INT — Foreign key → PRODUCT.product_num — NOT NULL
- report_content (Field) — TEXT
- qna_category_detail_num (Field2) — INT
- report_date (Field3) — TEXT
- report_processing_date (Field4) — TEXT
- report_is_accept (Field5) — VARCHAR(3)
REPORT_IMG (Untitled9)
- report_idx (Key) — INT — Foreign key → REPORT.report_idx — NOT NULL
- report_image_name (Field) — TEXT
- report_image_real_file (Field2) — TEXT
UPPAY (Untitled22)
- uppay_idx (Key) — INT — Primary key — NOT NULL
- member_id (Field) — VARCHAR(15)
- uppay_pay (Field2) — VARCHAR(10)
- uppay_use (Field3) — VARCHAR(50)
- uppay_date (Field4) — DATETIME
- uppay_remain (Field5) — VARCHAR(10)
WITHDRAW (Untitled21)
- withdraw_idx (Key) — INT — Primary key — NOT NULL
- owner_bank (Field) — VARCHAR(30)
- owner_acc (Field2) — VARCHAR(20)
- withdraw_bank (Field3) — VARCHAR(30)
- withdraw_acc (Field4) — VARCHAR(20)
- commission (Field5) — VARCHAR(10)
- product_price (Field6) — VARCHAR(10)
- member_id (Field7) — VARCHAR(15)
- member_name (Field8) — VARCHAR(10)
- method (Field9) — VARCHAR(20)
- buy_check (Field10) — VARCHAR(10)
- withdraw_date (Field11) — DATETIME
- product_num (Field12) — INT
- merchant_uid (Field13) — VARCHAR(30)