daangn

Tables (19)

Activity_area

  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • activearea_id — INT — Foreign key → Neighborhoods.area_id — NOT NULL
  • active_radius — INT — NOT NULL
  • auth_date — TIMESTAMP

Alarm

  • alarm_id — BIGINT — Primary key — NOT NULL
  • receiver_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • alarm_message — TEXT — NOT NULL
  • alarm_type — ENUM — NOT NULL
  • alarm_time — TIMESTAMP — NOT NULL

Alarm_keyword

  • keyword_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • keyword_name — VARCHAR(45) — NOT NULL
  • keyword_time — TIMESTAMP — NOT NULL

Buyer_reveiw

  • buyer_rating_id — BIGINT — Primary key — NOT NULL
  • buyer_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • buyer_score — INT — NOT NULL
  • buyer_comments — VARCHAR(45) — NOT NULL

Category

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(45) — NOT NULL

Cities

  • area_id — INT — Primary key — NOT NULL
  • region_id — INT — Foreign key → Regions.area_id — NOT NULL
  • area_code — VARCHAR(45) — NOT NULL
  • area_name — VARCHAR(50) — NOT NULL
  • area_version — VARCHAR(45) — NOT NULL

Districts

  • area_id — INT — Primary key — NOT NULL
  • cities_id — INT — Foreign key → Cities.area_id — NOT NULL
  • area_code — VARCHAR(45) — NOT NULL
  • area_name — VARCHAR(50) — NOT NULL

Item

  • item_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • seller_location — INT — Foreign key → Neighborhoods.area_id — NOT NULL
  • category — INT — Foreign key → Category.category_id — NOT NULL
  • item_price — DECIMAL(100, 0)
  • item_image — VARCHAR(45)
  • created_date — TIMESTAMP — NOT NULL
  • item_title — VARCHAR(100) — NOT NULL
  • item_body — MEDIUMTEXT — NOT NULL
  • post_status — ENUM — NOT NULL
  • deal_status — ENUM — NOT NULL
  • updated_date — TIMESTAMP — NOT NULL
  • post_views — INT
  • post_chats — INT

Item_interesting

  • interesting_id — INT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id
  • item_id — BIGINT — Foreign key → Item.item_id
  • interesting_created — TIMESTAMP

Neighborhoods

  • area_id — INT — Primary key — NOT NULL
  • district_id — INT — Foreign key → Districts.area_id — NOT NULL
  • area_code — VARCHAR(45) — NOT NULL
  • area_name — VARCHAR(45) — NOT NULL

Price_offer

  • offer_id — BIGINT — Primary key — NOT NULL
  • offerer_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • offer_price — INT — NOT NULL
  • offer_ok — TINYINT(1) — NOT NULL
  • offer_time — TIMESTAMP — NOT NULL

Regions

  • area_id — INT — Primary key — NOT NULL
  • area_code — VARCHAR(45) — NOT NULL
  • area_name — VARCHAR(50) — NOT NULL
  • area_version — VARCHAR(45) — NOT NULL

Seller_reveiw

  • seller_rating_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id
  • seller_rating — INT — NOT NULL
  • seller_comments — VARCHAR(45) — NOT NULL

User

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(45) — NOT NULL
  • phone_number — VARCHAR(11) — NOT NULL
  • registered_date — TIMESTAMP — NOT NULL
  • profile_picture — VARCHAR(100)
  • rating_score — NUMERIC(3,1) — NOT NULL
  • user_location — INT — NOT NULL
  • user_status — ENUM — NOT NULL

chat_message

  • chatmessage_id — BIGINT — Primary key — NOT NULL
  • chatroom_id — BIGINT — Foreign key → chat_room.chatroom_id — NOT NULL
  • sender_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • chat_message — VARCHAR(500) — NOT NULL
  • chat_read — TINYTEXT(1) — NOT NULL

chat_room

  • chatroom_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • buyer_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • chatroom_time — TIMESTAMP — NOT NULL

re_reply

  • rereply_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • reply_id — BIGINT — Foreign key → reply.reply_id — NOT NULL
  • rereply_comment — VARCHAR(45) — NOT NULL

reply

  • reply_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • reply_body — TEXT — NOT NULL
  • reply_time — TIMESTAMP — NOT NULL

user_blocked

  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • blocked_id — BIGINT — Foreign key → User.user_id
  • blocked_time — TIMESTAMP