test
Tables (14)
Achievement
- achievement_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- image_url — VARCHAR(255)
- condition — TEXT
- location — VARCHAR(255)
- created_by — INTEGER — Foreign key → Member.member_id
- created_at — TIMESTAMP — NOT NULL
- updated_by — INTEGER — Foreign key → Member.member_id
- updated_at — TIMESTAMP
Category
- category_id — INTEGER — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- brand — VARCHAR(100)
ChatMessage
- message_id — INTEGER — Primary key — NOT NULL
- chat_room_id — INTEGER — Foreign key → ChatRoom.chat_room_id
- sender_id — INTEGER — Foreign key → Member.member_id
- content — TEXT — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
- is_read — BOOLEAN
ChatRoom
- chat_room_id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → Post.post_id
- sender_id — INTEGER — Foreign key → Member.member_id
- receiver_id — INTEGER — Foreign key → Member.member_id
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
CollectionItem
- item_id — INTEGER — Primary key — NOT NULL
- category_id — INTEGER — Foreign key → Category.category_id
- owner_id — INTEGER — Foreign key → Member.member_id
- product_name — VARCHAR(255) — NOT NULL
- product_condition — VARCHAR(50)
- purchase_date — DATE
- purchase_place — VARCHAR(255)
- image_url — VARCHAR(255)
- price — DECIMAL(10,2)
- storage_location — VARCHAR(255)
- registration_date — TIMESTAMP — NOT NULL
Comment
- comment_id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → Post.post_id
- author_id — INTEGER — Foreign key → Member.member_id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
Member
- member_id — INTEGER — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_picture — VARCHAR(255)
- join_date — DATE — NOT NULL
- sns_link — VARCHAR(255)
- is_admin — BOOLEAN — NOT NULL
MemberAchievement
- member_id — INTEGER — Foreign key → Member.member_id — NOT NULL
- achievement_id — INTEGER — Foreign key → Achievement.achievement_id — NOT NULL
- acquired_at — TIMESTAMP — NOT NULL
Notification
- notification_id — INTEGER — Primary key — NOT NULL
- member_id — INTEGER — Foreign key → Member.member_id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- is_read — BOOLEAN
- chat_room_id — INTEGER — Foreign key → ChatRoom.chat_room_id
- post_id — INTEGER — Foreign key → Post.post_id
- comment_id — INTEGER — Foreign key → Comment.comment_id
- achievement_id — INTEGER — Foreign key → Achievement.achievement_id
Post
- post_id — INTEGER — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- author_id — INTEGER — Foreign key → Member.member_id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- updated_by — INTEGER — Foreign key → Member.member_id
- deleted_at — TIMESTAMP
- deleted_by — INTEGER — Foreign key → Member.member_id
- views — INTEGER
- likes — INTEGER
- collection_item_id — INTEGER — Foreign key → CollectionItem.item_id
- trade_price — DECIMAL(10,2)
- trade_status — VARCHAR(50)
PostTag
- post_id — INTEGER — Foreign key → Post.post_id — NOT NULL
- tag_id — INTEGER — Foreign key → Tag.tag_id — NOT NULL
Report
- report_id — INTEGER — Primary key — NOT NULL
- reporter_id — INTEGER — Foreign key → Member.member_id
- reported_id — INTEGER — Foreign key → Member.member_id
- post_id — INTEGER — Foreign key → Post.post_id
- comment_id — INTEGER — Foreign key → Comment.comment_id
- content — TEXT — NOT NULL
- reported_at — TIMESTAMP — NOT NULL
Tag
- tag_id — INTEGER — Primary key — NOT NULL
- tag_name — VARCHAR(100) — NOT NULL
Wiki
- wiki_id — INTEGER — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- subject — VARCHAR(255)
- category — VARCHAR(100)
- content — TEXT — NOT NULL
- author_id — INTEGER — Foreign key → Member.member_id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- updated_by — INTEGER — Foreign key → Member.member_id
- deleted_at — TIMESTAMP
- deleted_by — INTEGER — Foreign key → Member.member_id