Main_Project

Tables (17)

Bookmark (bookmark)

  • bookmark_id (Key) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • buying_id (buyingId) — bigint — Foreign key → Buying.buying_id — NOT NULL
  • selling_id (sellingId) — bigint — Foreign key → Selling.selling_id — NOT NULL

Buying (buying)

  • buying_id (buyingId) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • title — text — NOT NULL
  • body — text — NOT NULL
  • location — varchar(63) — NOT NULL
  • price (Field) — int — NOT NULL
  • start_work_time — datetime — NOT NULL
  • end_work_time — datetime — NOT NULL
  • categories (categoryId) — bigint — Foreign key → Category.category_id — NOT NULL
  • created_at — timestamp — NOT NULL
  • last_modified_at — timestamp — NOT NULL
  • relisted_at — timestamp
  • status — enum — NOT NULL
  • isPremium — boolean — NOT NULL

Buying_Apply (buyingApply)

  • buying_apply_id (buyingapply_id) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • buying_id (buyingId) — bigint — Foreign key → Buying.buying_id — NOT NULL
  • apply_status (is_matched) — enum — NOT NULL

Buying_Like (buyingLikes)

  • buying_like_id (buyingLikesId) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • like_id (Key) — bigint — Foreign key → Like.like_id — NOT NULL

Buying_Review (buyingReview)

  • buying_review_id (buyingReviewId) — bigint — Primary key — NOT NULL
  • reviewer_id (reviewer) — bigint — Foreign key → Member.member_id — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • buying_id (buyingId) — bigint — Foreign key → Buying.buying_id — NOT NULL
  • body — text — NOT NULL
  • second_body — text

Category (category)

  • category_id (categoryId) — bigint — Primary key — NOT NULL
  • category_name — varchar(255) — NOT NULL

ChatRoom (chatRoom)

  • chatroom_id — bigint — Primary key — NOT NULL
  • first_member_id — bigint — Foreign key → Member.member_id — NOT NULL
  • second_member_id — bigint — Foreign key → Member.member_id — NOT NULL
  • message_id — bigint — Foreign key → Message.message_id — NOT NULL
  • status — enum — NOT NULL

File_Info (file)

  • file_id (filesId) — bigint — Primary key — NOT NULL
  • file_name (fileName) — varchar(255) — NOT NULL
  • type — enum — NOT NULL

Like (Untitled)

  • like_id (Key) — bigint — Primary key — NOT NULL
  • type (Field) — enum — NOT NULL

Member (member)

  • member_id (memberId) — bigint — Primary key — NOT NULL
  • profile_id (Key) — bigint — Foreign key → Profile.profile_id — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(63) — NOT NULL
  • nick_name (nickname) — varchar(15) — NOT NULL
  • profile_image — bigint — Foreign key → File_Info.file_id — NOT NULL
  • about — text — NOT NULL
  • member_status — enum — NOT NULL
  • chatroom_id — bigint — Foreign key → ChatRoom.chatroom_id — NOT NULL

Message (message)

  • message_id (messageId) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • message — text — NOT NULL
  • created_at — timestamp

Profile (Untitled2)

  • profile_id (Key) — bigint — Primary key — NOT NULL
  • buy_like_count (Field2) — int — NOT NULL
  • buy_dislike_count (Field3) — int — NOT NULL
  • sell_like_count (Field4) — int — NOT NULL
  • sell_dislike_count (Field5) — int — NOT NULL
  • completed_buying_count (Field6) — int
  • completed_selling_count (Field7) — int
  • buyer_point (Field8) — int
  • seller_point (Field9) — int

Schedule (schedule)

  • schedule_id (scheduleId) — bigint — Primary key — NOT NULL
  • buying_id (buyingId) — bigint — Foreign key → Buying.buying_id
  • selling_id (sellingId) — bigint — Foreign key → Selling.selling_id
  • start_work_time — datetime — NOT NULL
  • end_work_time — datetime — NOT NULL
  • location — varchar(63)
  • profile_id (Key) — bigint — Foreign key → Profile.profile_id — NOT NULL

Selling (selling)

  • selling_id (sellingId) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • title — text — NOT NULL
  • body — text — NOT NULL
  • location — varchar(63)
  • price (Field) — int — NOT NULL
  • start_work_time — datetime — NOT NULL
  • end_work_time — datetime — NOT NULL
  • categories (categoryId) — bigint — Foreign key → Category.category_id — NOT NULL
  • created_at (ccreated_at) — timestamp — NOT NULL
  • last_modified_at — timestamp — NOT NULL
  • relisted_at — timestamp
  • status — enum — NOT NULL
  • is_premium — boolean — NOT NULL

Selling_Apply (CopyOfbuyingApply)

  • selling_apply_id (buyingapply_id) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • selling_id (sellingId) — bigint — Foreign key → Selling.selling_id — NOT NULL
  • apply_status (is_matched) — enum — NOT NULL

Selling_Like (sellingLikes)

  • selling_like_id (sellingLikesId) — bigint — Primary key — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • like_id (Key) — bigint — Foreign key → Like.like_id — NOT NULL

Selling_Review (sellingReview)

  • selling_review_id (sellingReviewId) — bigint — Primary key — NOT NULL
  • reviewer_id (reviewer) — bigint — Foreign key → Member.member_id — NOT NULL
  • member_id (memberId) — bigint — Foreign key → Member.member_id — NOT NULL
  • selling_id (sellingId) — bigint — Foreign key → Selling.selling_id — NOT NULL
  • body — text — NOT NULL
  • second_body — text