usedResell
Tables (5)
board (동네생활 게시판)
- idx (Key) — int — Primary key — NOT NULL
- nickname (FK) — varchar(45) — Foreign key → member.idx — NOT NULL
- title (Field) — varchar(50)
- hit_cnt (Field2) — int
- contents (Field3) — varchar(800)
- place (Field4) — varchar(50)
- create_daee (Field5) — datetime
- likes (Field6) — int
- cate (Field7) — varchar(45)
- id (Field8) — varchar(45)
comment (게시판 댓글)
- comment_idx (Key) — int — Primary key — NOT NULL
- board_idx (FK) — int — Foreign key → board.idx — NOT NULL
- nickname (Field) — varchar(45)
- place (Field2) — varchar(50)
- create_date (Field3) — datetime
- likes (Field4) — int
favorite (관심)
- idx (Key) — int — Primary key — NOT NULL
- nickname (FK) — varchar(45) — Foreign key → member.idx — NOT NULL
- product (FK2) — varchar(40) — Foreign key — NOT NULL
- favorite (Field2) — int
- create_date (Field3) — datetime
- update_date (Field4) — datetime
member (회원)
- idx (Key) — int — Primary key — NOT NULL
- id (Field) — varchar(45)
- pw (Field2) — varchar(45)
- nickname (FK) — varchar(45)
- name (Field3) — varchar(45)
- phone (Field4) — varchar(45)
- addr (Field5)
tradeChat (거래 문의 및 구매)
- idx (Key) — int — Primary key — NOT NULL
- seller (FK) — varchar(45) — Foreign key → member.idx — NOT NULL
- buyer (FK2) — varchar(45) — Foreign key → member.idx — NOT NULL
- create_date (Field) — datetime
- comment (Field2) — varchar(500)