oiljang
Tables (15)
category_info
- category_code — INTEGER — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- upper_category_code — INTEGER
inq_category_info (inq_category)
- inq_cate_code — INTEGER — Primary key — NOT NULL
- inq_cate_name — VARCHAR(30) — NOT NULL
inquiry_info (inquiry)
- inq_code — INTEGER — Primary key — NOT NULL
- inq_title — VARCHAR(30) — NOT NULL
- inq_content — VARCHAR(1000) — NOT NULL
- inq_answer — VARCHAR(1000)
- inq_time — DATETIME — NOT NULL
- ref_user_code — INTEGER — Foreign key → user_info.user_code — NOT NULL
- ref_inq_cate_code — INTEGER — Foreign key → inq_category_info.inq_cate_code — NOT NULL
- inq_status — VARCHAR(10) — NOT NULL
message_info (message)
- msg_code — INTEGER — Primary key — NOT NULL
- msg_content — VARCHAR(1000) — NOT NULL
- msg_status — VARCHAR(30) — NOT NULL
- msg_time — DATETIME — NOT NULL
- ref_product_code — INTEGER — Foreign key → product_info.product_code — NOT NULL
- sender_code — INTEGER — Foreign key → user_info.user_code — NOT NULL
- receiver_code — INTEGER — Foreign key → user_info.user_code — NOT NULL
- msg_delete_code — INTEGER — Foreign key → msg_delete_info.msg_delete_code — NOT NULL
msg_delete_info
- msg_delete_code — INTEGER — Primary key — NOT NULL
- msg_delete_status — VARCHAR(30) — NOT NULL
- Field
my_calendar_info
- my_calendar_code — INTEGER — Primary key — NOT NULL
- ref_user_code — INTEGER — Foreign key → user_info.user_code — NOT NULL
- calendar_content — VARCHAR(500) — NOT NULL
- calendar_date — DATE — NOT NULL
pro_image_info
- pro_image_code — INTEGER — Primary key — NOT NULL
- ref_product_code — INTEGER — Foreign key → product_info.product_code — NOT NULL
- pro_image_origin_name — VARCHAR(500) — NOT NULL
- pro_image_db_name — VARCHAR(500) — NOT NULL
- pro_image_origin_addr — VARCHAR(500) — NOT NULL
product_info
- product_code — INTEGER — Primary key — NOT NULL
- product_thumb_addr — VARCHAR(500) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- product_price — INTEGER — NOT NULL
- product_desc — VARCHAR(500) — NOT NULL
- enroll_datetime — DATETIME — NOT NULL
- view_count — INTEGER — NOT NULL
- ref_user_code — INTEGER — NOT NULL
- ref_category_code — INTEGER — Foreign key → category_info.category_code — NOT NULL
- wish_place_to_trade — VARCHAR(200) — NOT NULL
- sell_status_code — INTEGER — Foreign key → sell_status_info.sell_status_code — NOT NULL
report_category_info (report_category)
- report_category_no — INTEGER — Primary key — NOT NULL
- report_category_code — VARCHAR(255) — NOT NULL
report_info (report)
- report_no — INTEGER — Primary key — NOT NULL
- report_comment — VARCHAR(255) — NOT NULL
- report_date — DATE — NOT NULL
- ref_report_category_no — INTEGER — Foreign key → report_category_info.report_category_no — NOT NULL
- process_distinction — VARCHAR(100)
- process_comment — VARCHAR(255)
- process_date — DATE
- report_user_nick — VARCHAR(50) — NOT NULL
- product_code — INTEGER — Foreign key → product_info.product_code — NOT NULL
- sell_status_code — INTEGER — Foreign key → sell_status_info.sell_status_code — NOT NULL
sell_status_info
- sell_status_code — INTEGER — Primary key — NOT NULL
- sell_status — VARCHAR(30) — NOT NULL
user_info
- user_code — int — Primary key — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- id — VARCHAR(100) — NOT NULL
- pwd — VARCHAR(100) — NOT NULL
- birthdate — VARCHAR(30) — NOT NULL
- gender — VARCHAR(30) — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- email — VARCHAR(30)
- enroll_date — datetime — NOT NULL
- enroll_type — VARCHAR(30) — NOT NULL
- auth_name — VARCHAR(30) — NOT NULL
- verify_status — VARCHAR(1) — NOT NULL
- withdraw_status — VARCHAR(1) — NOT NULL
- profile_Image_Url — varchar(300)
user_profile_info (user_profile)
- profile_code — INTEGER — Primary key — NOT NULL
- ref_user_code — int — Foreign key → user_info.user_code — NOT NULL
- user_image_origin_name — VARCHAR(300) — NOT NULL
- user_image_name — VARCHAR(300) — NOT NULL
- user_image_origin_addr — VARCHAR(500) — NOT NULL
- user_image_thumb_addr — VARCHAR(500) — NOT NULL
user_sanctions_info (user_sanctions)
- sanctions_code — INTEGER — Primary key — NOT NULL
- ref_user_code (user_code) — INTEGER — Foreign key → user_info.user_code — NOT NULL
- sanctions_date (Field) — DATE
- managerDate (Field2) — DATE
wish_list_info (wish_list)
- wish_code — INTEGER — Primary key — NOT NULL
- ref_product_code — INTEGER — Foreign key → product_info.product_code — NOT NULL
- ref_user_code — INTEGER — Foreign key → user_info.user_code — NOT NULL