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