asasasas

Tables (9)

Category

  • categoryIdx — BIGINT — Primary key — NOT NULL
  • contents — varchar(200) — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

Item

  • itemIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • categoryIdx — BIGINT — Foreign key → Category.categoryIdx — NOT NULL
  • itemName — VARCHAR(200) — NOT NULL — 상품 이름
  • price — INT — NOT NULL — 가격
  • discription — VARCHAR(1000) — NOT NULL — 상품 설명
  • like — INT — NOT NULL — 좋아요 수
  • viewed — INT — NOT NULL — 조회수
  • chat — INT — NOT NULL — 채팅 수
  • tradeType — INT — NOT NULL — 나눔인지 그런거
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화
  • pictureIdx — BIGINT
  • pictureUrl — BIGINT

ItemLiked

  • likeIdx — BIGINT — Primary key — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

Location

  • locationIdx — BIGINT — Primary key — NOT NULL
  • locationContent — VARCHAR(100) — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

Picture

  • pictureIdx — BIGINT — Primary key — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • pictureUrl — VARCHAR(2000) — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

Search

  • searchIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • contents — VARCHAR(30) — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

Trade

  • TradeIdx — BIGINT — Primary key — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — int — NOT NULL — 0:비활성화, 1:활성화

User

  • userIdx — BIGINT — Primary key — NOT NULL
  • userName — VARCHAR(50) — NOT NULL
  • age — INT — NOT NULL
  • profileImageUrl — VARCHAR(2000) — NOT NULL
  • temperature — FLOAT — NOT NULL
  • phoneNumber — varchar(15) — NOT NULL — 010-0000-0000
  • location — VARCHAR(100)
  • Field2
  • email — varchar(45)
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화

UserLocation

  • locationIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • locationIdx2 — BIGINT — Foreign key → Location.locationIdx — NOT NULL
  • locationRange — INT — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL — 0:비활성화, 1:활성화