Aproject

Tables (39)

AUCTION

  • AUCTION_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • CHOICE_OPTION_LIST — LIST<STRING>
  • COLOR_OPTION_LIST — LIST<STRING>
  • TOTAL_CAR_PRICE — INTEGER
  • PURCHASE_METHOD_LIST — LIST<STRING>
  • DELIVERY_LOCATION — STRING
  • AUCTION_STATUS — BOOLEAN
  • AUCTION_CREATED_AT — LOCALDATETIME

Article

  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • BOARD_PK — BIGINT — Foreign key → Board.BOARD_PK
  • ARTICLE_TITLE — STRING
  • ARTICLE_CONTENT — STRING
  • ARTICLE_ORIGIN_CONTENT — STRING
  • ARTICLE_CREATED_AT — LOCALDATETIME
  • ARTICLE_UPDATED_AT — LOCALDATETIME
  • READ_COUNT — int
  • LIKE_COUNT — int
  • DISLIKE_COUNT — int
  • NEUTRAL_COUNT — int
  • REPORT_COUNT — int
  • SCRAP_COUNT — int
  • COMMENT_COUNT — int

ArticleReaction

  • REACTION_PK — BIGINT — Primary key — NOT NULL
  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Foreign key → Article.ARTICLE_PK — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • REACTION_TYPE — ENUM

ArticleScrap

  • SCRAP_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Foreign key → Article.ARTICLE_PK — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • SCRAP_DISCLOSURE — BOOLEAN

BASIC_OPTION

  • BASIC_OPTION_PK — LONG — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • STANDARD_OPTIONS — LIST<STRING>
  • OPTIONAL_OPTIONS — LIST<STRING>

BASIC_OPTION__DEFINE

  • BASIC_OPTION_DEFINE_PK — STRING — Primary key — NOT NULL
  • CATEGORY — STRING
  • OPTION_NAME — STRING
  • OPTION_DESCRIPTION — STRING

BRAND

  • BRAND_PK — STRING — Primary key — NOT NULL
  • COUNTRY_PK — STRING — Foreign key → COUNTRY.COUNTRY_PK — NOT NULL
  • BRAND_NAME — STRING

Board

  • BOARD_PK — BIGINT
  • BOARD_NAME — STRING — NOT NULL

CAPITAL

  • CAPITAL_PK — LONG — Primary key — NOT NULL
  • CAPITAL_NAME — STRING

CAR

  • CAR_PK — STRING — Primary key — NOT NULL
  • COUNTRY_PK — STRING — Foreign key → COUNTRY.COUNTRY_PK — NOT NULL
  • BRAND_PK — STRING — Foreign key → BRAND.BRAND_PK — NOT NULL
  • MODEL_PK — STRING — Foreign key → MODEL.MODEL_PK — NOT NULL
  • DETAIL_MODEL_PK — STRING — Foreign key → DETAIL_MODEL.DETAIL_MODEL_PK — NOT NULL
  • CAR_YEAR — STRING
  • ENGINE_INFO — STRING
  • TRIM_NAME — STRING
  • FUEL_TYPE — STRING
  • CAR_CLASS — STRING
  • CAR_PRICE — INTEGER
  • CAR_STATUS — STRING

CAR_INTEREST

  • CAR_INTEREST_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • CAR_ID — BIGINT
  • UPDATED_AT — DATETIME

CAR_SPEC

  • CAR_SPEC_PK — LONG — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • CAR_HEIGHT — STRING
  • CAR_WIDTH — STRING
  • CAR_WHEELBASE — STRING
  • CAR_LENGTH — STRING
  • CAR_WEIGHT — STRING
  • TRUNK_SUITCASE — STRING
  • TRUNK_STROLLER — STRING
  • TRUNK_GOLF_BAG — STRING
  • CAR_SEATING — STRING
  • FUEL_EFFICIENCY — DOUBLE
  • ENGINE_DISPLACEMENT — INTEGER
  • ENGINE_TYPE — STRING
  • ENGINE_TORQUE — STRING
  • ENGINE_POWER — STRING
  • TRANSMISSION_INFO — STRING
  • ZERO_TO_HUNDRED — STRING
  • MOTOR_TORQUE — STRING
  • MOTOR_POWER — STRING
  • MOTOR_MAX_SPEED — STRING
  • MOTOR_ZERO_TO_HUNDRED — STRING
  • MOTOR_BATTERTY_CAPACITY — STRING
  • MOTOR_CHARGING — STRING
  • MOTOR_FAST_CHARGING — STRING
  • MOTOR_SLOW_CHARGING — STRING
  • MOTOR_DRIVING_RANGE — STRING

CASH

  • CASH_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • IN_PRODUCT_PK — BIGINT — NOT NULL
  • TYPE — ENUM
  • CASH_CHARGE — BIGINT
  • CASH_USED — BIGINT
  • UPDATED_AT — DATETIME

CHOICE_OPTION

  • CHOICE_OPTION_PK — STRING — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • CHOICE_OPTION_NAME — STRING
  • CHOICE_OPTION_PRICE — INTEGER
  • CHOICE_OPTION_DESCRIPTION — STRING
  • CONNECT_CHOICE_OPTION — LIST<STRING>
  • REMOVE_CHOICE_OPTION — LIST<STRING>

COLOR_OPTION

  • COLOR_OPTION_PK — STRING — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • COLOR_OPTION_TYPE — STRING
  • COLOR_OPTION_PRICE — INTEGER
  • COLOR_OPTION_NAME — STRING
  • COLOR_OPTION_CODES — LIST<STRING>
  • COLOR_OPTION_COUNT — INTEGER
  • REMOVE_EXTERIOR_COLORS — LIST<STRING>
  • REMOVE_INTERIOR_COLORS — LIST<STRING>
  • Field — VARCHAR(255)

COMMENT

  • COMMENT_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Foreign key → Article.ARTICLE_PK — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • COMMENT_CONTENT — STRING
  • CREATED_AT — DATETIME
  • LIKE_COUNT — int
  • DISLIKE_COUNT — int
  • NEUTRAL_COUNT — int

CONSULT_HOTDEAL

  • CONSULT_HOTDEAL_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • HOT_DEAL_PK — BIGINT(AUTO-INCREMENT) — Foreign key → HOTDEAL.HOT_DEAL_PK — NOT NULL
  • DEALER_PK — BIGINT — Foreign key → HOTDEAL.DEALER_PK — NOT NULL
  • USER_PK2 — BIGINT — Foreign key → HOTDEAL.USER_PK — NOT NULL
  • CONSULT_HOTDEAL_CREATED_AT — LOCALDATETIME

CONTRACT

  • CONTRACT_NAME — STRING — Primary key — NOT NULL

COUNTRY

  • COUNTRY_PK — STRING — Primary key — NOT NULL
  • COUNTRY_NAME — STRING

Comment

  • COMMENT_PK — INT(AUTO-INCREMENT) — Primary key — NOT NULL
  • COMMENT_CONTENT — STRING
  • COMMENT_CREATETIME — LOCALDATETIME
  • COMMENT_UPDATETIME — LOCALDATETIME
  • COMMENT_LIKECOUNT — INT(0)
  • COMMENT_DISLIKECOUNT — INT(0)
  • Field — VARCHAR(255)

CopyOfMember2

  • USER_PK — BIGINT — Primary key — NOT NULL
  • USER_ID — STRING
  • EMAIL — STRING
  • USER_TYPE — ENUM
  • REGISTER_BY — ENUM
  • PASSWORD — STRING
  • NICKNAME — STRING
  • PROFILE_IMAGE — STRING
  • PHONE_NUMBER — _
  • PHONE_NUMBER_2 — STRING
  • ADDRESS_1 — STRING
  • ADDRESS_2 — STRING
  • POST_CODE — STRING
  • MARKETING_1 — BOOLEAN
  • MARKETING_2 — BOOLEAN
  • MARKETING_3 — BOOLEAN
  • EXP — BIGINT
  • CASH — BIGINT
  • CASH_CHARGE_COUNT — BIGINT
  • CASH_USED_COUNT — BIGINT
  • CASH_CHARGE_TOTAL — BIGINT
  • POINT — BIGINT
  • POINT_USED_COUNT — BIGINT
  • EVENT_POINT — BIGINT
  • EVENT_POINT_ENTRY — BIGINT
  • POST_COUNT — BIGINT
  • COMMENT_COUNT — BIGINT
  • ADULT_VERIFICATION — BOOLEAN
  • REGISTERED_AT — DATETIME
  • LAST_LOGIN — DATETIME

DEALER

  • DEALER_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • BUSINESS_CARD — STRING
  • BRAND — STRING
  • COMPANY — STRING
  • EXHIBITION_LOCATION — STRING
  • RANK — STRING
  • SOLD — BIGINT
  • GRADE — FLOAT
  • REVIEW_COUNT — BIGINT
  • VERIFY — BOOLEAN

DEALER_BID

  • DEALER_BID_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • AUCTION_PK — BIGINT(AUTO-INCREMENT) — Foreign key → AUCTION.AUCTION_PK — NOT NULL
  • DEALER_PK — BIGINT — Foreign key → DEALER.DEALER_PK — NOT NULL
  • DISCOUNT_PRICE — INTEGER
  • DEALER_BID_CREATED_AT — LOCALDATETIME
  • DEALER_BID_UPDATED_AT — LOCALDATETIME

DETAIL_MODEL

  • DETAIL_MODEL_PK — STRING — Primary key — NOT NULL
  • MODEL_PK2 — STRING — Foreign key → MODEL.MODEL_PK — NOT NULL
  • DETAIL_MODEL_NAME — STRING

ESTIMATE

  • ESTIMATE_PK — LONG — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • COUNTRY_PK — VARCHAR(255) — Foreign key → CAR.COUNTRY_PK — NOT NULL
  • BRAND_PK — VARCHAR(255) — Foreign key → CAR.BRAND_PK — NOT NULL
  • MODEL_PK — VARCHAR(255) — Foreign key → CAR.MODEL_PK — NOT NULL
  • DETAIL_MODEL_PK — VARCHAR(255) — Foreign key → CAR.DETAIL_MODEL_PK — NOT NULL
  • TOTAL_CAR_PRICE — INT
  • CONTRACT_METHOD — STRING
  • CAR_YEAR — STRING
  • ENGINE_INFO — STRING
  • TRIM_NAME — STRING
  • FUEL_TYPE — STRING
  • CAR_CLASS — STRING
  • CAR_PRICE — INT
  • Field7 — VARCHAR(255)
  • DEPOSIT — INT
  • ADVACE_PAYMENT — INT
  • MONTH — INT
  • Field11 — VARCHAR(255)
  • Field12 — VARCHAR(255)
  • Field6 — VARCHAR(255)
  • KM — STRING
  • Field — VARCHAR(255)

EVENT_POINT

  • EVENT_POINT_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • IN_PRODUCT_PK — BIGINT — NOT NULL
  • TYPE — ENUM
  • EVENT_POINT_USE — BIGINT
  • EVENT_POINT_GAIN — BIGINT
  • UPDATED_AT — DATETIME

EXP

  • EXP_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • TYPE — ENUM
  • INCREASE — BIGINT
  • DECREASE — BIGINT
  • UPDATED_AT — DATETIME

HOTDEAL

  • HOT_DEAL_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • DEALER_PK — BIGINT — Foreign key → DEALER.DEALER_PK — NOT NULL
  • USER_PK — BIGINT — Foreign key → DEALER.USER_PK — NOT NULL
  • CHOICE_OPTION_LIST — LIST<STRING>
  • COLOR_OPTION_LIST — LIST<STRING>
  • TOTAL_CAR_PRICE — INTEGER
  • DISCOUNT_PRICE — INTEGER
  • DEALER_SERVICE_LIST — LIST<STRING>
  • CAR_INVENTORY — INTEGER
  • PURCHASE_METHOD_LIST — LIST<STRING>
  • CAR_CONDITION_LIST — LIST<STRING>
  • LIKED_COUNT — INTEGER
  • CAR_IMAGE — MULTIPART
  • HOTDEAL_CREATED_AT — LOCALDATETIME
  • HOTDEAL_UPDATED_AT — LOCALDATETIME
  • HOTDEAL_END_AT — LOCALDATETIME

Hashtag

  • HASHTAG_NAME — STRING — Primary key — NOT NULL
  • HASHTAG_PK — BIGINT(AUTO-INCREMENT)
  • HASHTAG_COUNT — INT(0)

Image

  • IMAGE_PK — BIGINT — Primary key — NOT NULL
  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Foreign key → Article.ARTICLE_PK — NOT NULL
  • IMAGE_NAME — STRING
  • IMAGE_PATH — STRING

KM

  • KM — INTEGER — Primary key — NOT NULL
  • Field — VARCHAR(255)

MODEL

  • MODEL_PK — STRING — Primary key — NOT NULL
  • BRAND_PK — STRING — Foreign key → BRAND.BRAND_PK — NOT NULL
  • MODEL_NAME — STRING

MONTH

  • MONTH — INTEGER — Primary key — NOT NULL
  • Field — VARCHAR(255)

Member

  • USER_PK — BIGINT — Primary key — NOT NULL
  • USER_ID — STRING
  • EMAIL — STRING
  • USER_TYPE — ENUM
  • REGISTER_BY — ENUM
  • PASSWORD — STRING
  • NICKNAME — STRING
  • PROFILE_IMAGE — STRING
  • PHONE_NUMBER — _
  • PHONE_NUMBER_2 — STRING
  • ADDRESS_1 — STRING
  • ADDRESS_2 — STRING
  • POST_CODE — STRING
  • MARKETING_1 — BOOLEAN
  • MARKETING_2 — BOOLEAN
  • MARKETING_3 — BOOLEAN
  • EXP — BIGINT
  • CASH — BIGINT
  • CASH_CHARGE_COUNT — BIGINT
  • CASH_USED_COUNT — BIGINT
  • CASH_CHARGE_TOTAL — BIGINT
  • POINT — BIGINT
  • POINT_USED_COUNT — BIGINT
  • EVENT_POINT — BIGINT
  • EVENT_POINT_ENTRY — BIGINT
  • POST_COUNT — BIGINT
  • COMMENT_COUNT — BIGINT
  • ADULT_VERIFICATION — BOOLEAN
  • REGISTERED_AT — DATETIME
  • LAST_LOGIN — DATETIME

POINT

  • POINT_PK — BIGINT — Primary key — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • IN_PRODUCT_PK — BIGINT — NOT NULL
  • TYPE — ENUM
  • POINT_CHARGE — BIGINT
  • POINT_USED — BIGINT
  • UPDATED_AT — DATETIME

PRODUCT_IN_WEB

  • IN_PRODUCT_PK — BIGINT — Primary key — NOT NULL
  • IN_PRODUCT_NAME — STRING
  • POINT_USEABILITY — ENUM
  • COST — FLOAT

Reply

  • REPLY_PK — INT(AUTO-INCREMENT) — Primary key — NOT NULL
  • REPLY_CONTENT — STRING
  • REPLY_CREATETIME — LOCALDATETIME
  • REPLY_UPDATETIME — LOCALDATETIME
  • REPLY_LIKECOUNT — INT(0)
  • REPLY_DISLIKECOUNT — INT(0)

Report

  • REPORT_PK — BIGINT(AUTO-INCREMENT) — Primary key — NOT NULL
  • ARTICLE_PK — BIGINT(AUTO-INCREMENT) — Foreign key → Article.ARTICLE_PK — NOT NULL
  • USER_PK — BIGINT — Foreign key → Member.USER_PK — NOT NULL
  • REPORT_TITLE — STRING
  • REPORT_CONTENT — STRING
  • REPORT_CREATED_AT — STRING

VALUE

  • VALUE_PK — LONG — Primary key — NOT NULL
  • CAR_PK — STRING — Foreign key → CAR.CAR_PK — NOT NULL
  • CAPITAL_PK — LONG — Foreign key → CAPITAL.CAPITAL_PK — NOT NULL
  • CONTRACT_NAME — STRING — Foreign key → CONTRACT.CONTRACT_NAME — NOT NULL
  • 3615000 — FLOAT
  • 3620000 — FLOAT
  • 3625000 — FLOAT
  • 3630000 — FLOAT
  • 3635000 — FLOAT
  • 3640000 — FLOAT
  • 36 — FLOAT
  • 4815000 — FLOAT
  • 4820000 — FLOAT
  • 4825000 — FLOAT
  • 4830000 — FLOAT
  • 4835000 — FLOAT
  • 4840000 — FLOAT
  • 48 — FLOAT
  • 6015000 — FLOAT
  • 6020000 — FLOAT
  • 6025000 — FLOAT
  • 6030000 — FLOAT
  • 6035000 — FLOAT
  • 6040000 — FLOAT
  • 60 — FLOAT
  • 서울 — INTEGER
  • 경기 — INTEGER
  • 인천 — INTEGER
  • 강원 — INTEGER
  • 대전 — INTEGER
  • 세종 — INTEGER
  • 충북 — INTEGER
  • 충남 — INTEGER
  • 부산 — INTEGER
  • 대구 — INTEGER
  • 울산 — INTEGER
  • 경북 — INTEGER
  • 경남 — INTEGER
  • 광주 — INTEGER
  • 전북 — INTEGER
  • 전남 — INTEGER
  • 제주 — INTEGER