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:활성화