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 — 예약날짜