WaterMelon
Tables (11)
AUTHENTICATION
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- isAuth (IS_AUTH) — int — NOT NULL — 인증여부
- code (CODE) — varchar(255) — NOT NULL — 인증코드
DEAL_POST
- id (ID) — int — Primary key — NOT NULL — 거래글아이디
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- title (TITLE) — varchar(255) — NOT NULL — 거래글제목
- price (PRICE) — int — NOT NULL — 거래금액
- content (CONTENT) — varchar(255) — NOT NULL — 거래글내용
- createdDate (CREATE_DATE) — datetime — NOT NULL — 생성시간
- modifiedDate (MODIFY_DATE) — datetime — NOT NULL — 수정시간
- pullingDate (PULL_DATE) — datetime — NOT NULL — 끌어올린시간
- pullingCnt (PULL_CNT) — int — NOT NULL — 끌어올린횟수
- dealState (DEAL_STATE) — char(1) — NOT NULL — 거래상태
- category (CATEGORY) — varchar(255) — NOT NULL — 거래글종류
DEAL_POST_IMAGE
- id (ID) — int — Primary key — NOT NULL — 거래글이미지아이디
- dealPostId (DEAL_POST_ID) — int — Foreign key → DEAL_POST.id — NOT NULL — 거래글아이디
- path (PATH) — varchar(255) — NOT NULL — 이미지저장경로
- dealId (DEAL_ID) — int — NOT NULL — 거래글 아이디
DEAL_REVIEW
- id (ID) — int — Primary key — NOT NULL — 거래리뷰아이디
- sellerId (SELLER_ID) — int — Foreign key → USER.id — NOT NULL — 리뷰쓰는유저아이디
- buyerId (BUYER_ID) — int — Foreign key → USER.id — NOT NULL — 리뷰받는유저아이디
- createdDate (CREATED_DATE) — datetime — NOT NULL — 생성시간
- modifiedDate (MODIFIED_DATE) — datetime — NOT NULL — 수정시간
- content (CONTENT) — varchar(255) — NOT NULL — 리뷰 내용
DEAL_SUCCESS
- dealPostId (DEAL_POST_ID) — int — Foreign key → DEAL_POST.id — NOT NULL — 거래글아이디
- buyerId (BUYER_ID) — int — Foreign key → USER.id — NOT NULL — 구매자아이디
- createdDate (CREATED_DATE) — datetime — NOT NULL — 생성시간
KEYWORD
- id (ID) — int — Primary key — NOT NULL — 키워드아이디
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- word (WORD) — varchar(255) — NOT NULL — 키워드내용
MANNER_REVIEW
- id (ID) — int — Primary key — NOT NULL — 매너리뷰아이디
- sellerId (SELLER_ID) — int — Foreign key → USER.id — NOT NULL — 평가하는유저아이디
- buyerId (BUYER_ID) — int — Foreign key → USER.id — NOT NULL — 평가받는유저아이디
- mannerCnt (MANNER_CNT) — int — NOT NULL — 매너갯수
- manner (MANNER) — int — NOT NULL — 받은매너(ENUM)
NOTIFICATION
- id (ID) — int — Primary key — NOT NULL — 공지아이디
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- content (CONTENT) — varchar(255) — NOT NULL — 공지내용
- createdDate (CREATED_DATE) — datetime — NOT NULL — 생성시간
- type (TYPE) — CHAR(1) — NOT NULL — 공지유형
USER
- id (ID) — int — Primary key — NOT NULL — 유저아이디
- email (EMAIL) — varchar(255) — NOT NULL — 유저이메일
- password (PASSWORD) — varchar(255) — NOT NULL — 유저패스워드
- image (IMAGE) — varchar(255) — 프로필이미지
- nickname (NICKNAME) — varchar(100) — NOT NULL — 유저닉네임
- role (ROLE) — varchar(50) — NOT NULL — 권한
- createdDate (CREATED_DATE) — datetime — NOT NULL — 생성시간
- modifiedDate (MODIFIED_DATE) — datetime — NOT NULL — 수정시간
USER_LIKE
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- dealPostId (DEAL_POST_ID) — int — Foreign key → DEAL_POST.id — NOT NULL — 거래글아이디
- createDate (CREATE_DATE) — datetime — NOT NULL — 생성시간
USER_RESIDENCE
- userId (USER_ID) — int — Foreign key → USER.id — NOT NULL — 유저아이디
- city_1 (CITY_1) — varchar(50) — NOT NULL — 시(ENUM)
- town_1 (TOWN_1) — varchar(50) — NOT NULL — 동(ENUM)
- city_2 (CITY_2) — varchar(50)
- town_2 — varchar(50)