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