dsf

Tables (19)

Category

  • categoryIdx — BIGINT — Primary key — NOT NULL
  • highLevelDivisionIdx — BIGINT — Foreign key → HighLevelDivision.highLevelDivisionIdx — NOT NULL
  • lowLevelDivisionIdx — BIGINT — Foreign key → LowLevelDivision.lowLevelDivisionIdx — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → Item.userIdx — NOT NULL

ChatLog

  • chatLogIdx — BIGINT — Primary key — NOT NULL
  • chatRoomIdx — BIGINT — Foreign key → ChatRoom.chatRoomIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → ChatRoom.userIdx — NOT NULL
  • counterpart — BIGINT — Foreign key → ChatRoom.counterpart — NOT NULL
  • emoticonIdx — BIGINT — Foreign key → Emoticon.emoticonIdx — NOT NULL — 0은 임티 x
  • Key — Foreign key — NOT NULL
  • Key2 — Foreign key — NOT NULL
  • range1 — INT — Foreign key — NOT NULL
  • text — VARCHAR(2000) — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

ChatRoom

  • chatRoomIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → Item.userIdx — NOT NULL
  • itemidx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • counterpart — BIGINT — Foreign key → User.userIdx — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

Emoticon

  • emoticonIdx — BIGINT — Primary key — NOT NULL
  • picture — VARCHAR(30) — NOT NULL — 파일이름이 숫자로됨

HighLevelDivision

  • highLevelDivisionIdx — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(20) — NOT NULL

Item

  • itemIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • itemName — VARCHAR(50) — NOT NULL
  • text — TEXT — NOT NULL
  • like — INT — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

ItemLiked

  • likeIdx — BIGINT — Primary key — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → Item.userIdx — NOT NULL
  • userIdx2 — BIGINT — Foreign key → User.userIdx — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

ItemPicture

  • pictureIdx — BIGINT — Primary key — NOT NULL
  • picture — VARCHAR(200)
  • initDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

KeyWord

  • keyWordIdx — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(50) — NOT NULL — Unique

KeyWordOf

  • keyWordOfIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • keyWordIdx — BIGINT — Foreign key → KeyWord.keyWordIdx — NOT NULL

Location

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

LowLevelDivision

  • lowLevelDivisionIdx — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(20) — NOT NULL

Notice

  • noticeIdx — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(200) — NOT NULL

NoticeOf

  • noticeOfIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • noticeIdx — BIGINT — Foreign key → Notice.noticeIdx — NOT NULL

PictureOf

  • pictureOfIdex — BIGINT — Primary key — NOT NULL
  • pictureIdx — BIGINT — Foreign key → ItemPicture.pictureIdx — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → Item.userIdx — NOT NULL
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL

Search

  • searchIdx — BIGINT — Primary key — NOT NULL
  • searchOfIdx — BIGINT — Foreign key → SearchOf.searchOfIdx — NOT NULL
  • userIdx — BIGINT — Foreign key → SearchOf.userIdx — NOT NULL
  • searchDate — TIMESTAMP — NOT NULL
  • contents — VARCHAR(30) — NOT NULL

SearchOf

  • searchOfIdx — BIGINT — Primary key — NOT NULL
  • userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL

Trade

  • TradeIdx — BIGINT — Primary key — NOT NULL
  • itemIdx — BIGINT — Foreign key → Item.itemIdx — NOT NULL
  • sellerIdx — BIGINT — Foreign key → Item.userIdx — NOT NULL
  • purchaserIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
  • tradeDate — TIMESTAMP — NOT NULL
  • status — int — NOT NULL

User

  • userIdx — BIGINT — Primary key — NOT NULL
  • userName — VARCHAR(50) — NOT NULL
  • age — INT — NOT NULL
  • picture — VARCHAR(200) — NOT NULL
  • temperature — FLOAT — NOT NULL
  • location2 — INT
  • range2 — INT
  • initDate — TIMESTAMP — NOT NULL
  • editDate — TIMESTAMP — NOT NULL
  • status — INT — NOT NULL
  • Field2