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