market

Tables (8)

blacklist

  • black_seq — int — Primary key — NOT NULL
  • id — varchar(20) — Foreign key → member.id — NOT NULL
  • email — varchar(30)
  • phone — varchar(20)

chatting_detail

  • chat_detail_seq — int — Primary key — NOT NULL
  • chat_seq — int — Foreign key → chatting_list.chat_seq — NOT NULL
  • customer — varchar(20) — Foreign key → chatting_list.customer — NOT NULL
  • trans_seq — int — Foreign key → chatting_list.trans_seq — NOT NULL
  • reg_member — varchar(20) — Foreign key → chatting_list.reg_member — NOT NULL
  • content — TEXT

chatting_list

  • chat_seq — int — Primary key — NOT NULL
  • customer — varchar(20) — Foreign key → member.id — NOT NULL
  • trans_seq — int — Foreign key → product.product_seq — NOT NULL
  • reg_member — varchar(20) — Foreign key → product.reg_member — NOT NULL

del_transaction

  • del_seq — int — Primary key — NOT NULL
  • trans_seq — int — Foreign key → product.product_seq — NOT NULL
  • reg_member — varchar(20) — Foreign key → product.reg_member — NOT NULL
  • title — varchar(30)
  • content — varchar(200)
  • reg_date — date
  • img_data — TEXT
  • view_cnt — int
  • like_cnt — int
  • price — int
  • trans_location — TEXT — { "address" : "부천시", "latitude": "", "longitude": "" }
  • trans_status — char(1)
  • category — varchar(20)
  • res_date — date — 예약날짜
  • del_date — date

fin_transaction

  • fin_seq — int — Primary key — NOT NULL
  • trans_seq — int — Foreign key → product.product_seq — NOT NULL
  • reg_member — varchar(20) — Foreign key → product.reg_member — NOT NULL
  • title — varchar(30)
  • content — varchar(200)
  • reg_date — date
  • img_data — TEXT
  • view_cnt — int
  • like_cnt — int
  • price — int
  • trans_location — TEXT — { "address" : "부천시", "latitude": "", "longitude": "" }
  • trans_status — char(1)
  • category — varchar(20)
  • res_date — date — 예약날짜
  • fin_date — date

like_transaction

  • like_seq — int — Primary key — NOT NULL
  • reg_member (id) — varchar(20) — Foreign key → member.id — NOT NULL
  • trans_seq — int — Foreign key → product.product_seq — NOT NULL
  • reg_member — varchar(20) — Foreign key → product.reg_member — NOT NULL
  • title — varchar(30)
  • content — varchar(200)
  • reg_date — date
  • img_data — TEXT
  • view_cnt — int
  • like_cnt — int
  • price — int
  • trans_location — TEXT — { "address" : "부천시", "latitude": "", "longitude": "" }
  • trans_status — char(1)
  • category — varchar(20)
  • res_date — date — 예약날짜

member

  • id — varchar(20) — Primary key — NOT NULL
  • pw — varchar(20)
  • email — varchar(30)
  • phone — varchar(20)
  • name — varchar(20)
  • location — TEXT — { "address" : "부천시", "latitude": "", "longitude": "" }
  • profile_img — TEXT
  • manner_temp — double
  • auth — int
  • category — varchar(20)
  • birth — varchar(10)
  • level — int

product

  • product_seq — int — Primary key — NOT NULL
  • reg_member — varchar(20) — Foreign key → member.id — NOT NULL
  • title — varchar(30)
  • content — varchar(300)
  • reg_date — date
  • img_data — TEXT
  • view_cnt — int
  • like_cnt — int
  • price — int
  • product_location — TEXT — { "address" : "부천시", "latitude": "", "longitude": "" }
  • product_status — char(1)
  • category — varchar(100)
  • res_date — date — 예약날짜