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)