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)