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