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