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