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)