offonoff-AB ERD

Tables (8)

Category (카테고리)

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)

ChoiceImage (선택 이미지)

  • id (PK) — bigint — Foreign key → Topic.id — NOT NULL
  • choice_a_img_url (Field)
  • choice_b_img_url (Field2)
  • created_at (Field3)
  • updated_at (Field4)

Comment (댓글)

  • id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK1) — bitint
  • topic_id (FK2) — bigint — Foreign key → Topic.id — NOT NULL
  • content (Field1) — varchar(255)
  • likes (Field4) — int
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

CommentLike (댓글 좋아요)

  • member_id (PK) — bigint — Foreign key → Member.id — NOT NULL
  • comment_id (PK2) — bigint — Foreign key → Comment.id — NOT NULL
  • status (Field) — tinyint(1)
  • created_at (Field2)
  • updated_at (Field3)

Member (회원)

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field1) — varchar(255)
  • nickname (Field2) — varhchar(255)
  • profile_img_url (Field12)
  • birth (Field9)
  • gender (Field10)
  • job (Field11) — varchar(255)
  • updated_at (Field8)
  • created_at (Field7)
  • topic_expire (Field3)
  • comment_like (Field4)
  • topic_vote (Field5)
  • topic_comment (Field6)

Topic (토픽)

  • id (PK) — bigint — Primary key — NOT NULL
  • title (Field1) — varchar(255)
  • member_id (PK2) — bigint — Foreign key → Member.id — NOT NULL
  • category_id (PK3) — bigint — Foreign key → Category.id — NOT NULL
  • side (Field3) — enum('TOPIC_A', 'TOPIC_B')
  • description (Field5) — varchar(255)
  • status (Field10) — enum
  • comments (Field2) — int
  • votes (Field4) — int
  • blocks (Field6) — int
  • created_at (Field7) — timestamp
  • updated_at (Field9)
  • expire_at (Field8) — timestamp

TopicBlock (토픽 블락)

  • id (PK) — bigint — Foreign key → Member.id — NOT NULL
  • id (PK2) — bigint — Foreign key → Topic.id — NOT NULL
  • status (Field3) — tinyint(1)
  • created_at (Field)
  • updated_ad (Field2)

Vote (투표)

  • member_id (PK1) — bigint — Foreign key → Member.id — NOT NULL
  • topic_id (PK2) — bigint — Foreign key → Topic.id — NOT NULL
  • choice (Field) — enum('CHOICE_A', 'CHOID_B')
  • created_at (Field2)
  • updated_at (Field3)