ㅇ
Tables (6)
Category
- id — BIGINT
- category_name — VARCHAR(255)
- share_type_cd — BIGINT
- user_id — BIGINT
- buddy_id — BIGINT
- delete_tf — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Code
- id — BIGINT
- group — VARCHAR(50)
- group_name — VARCHAR(255)
- code — BIGINT
- code_name — VARCHAR(255)
- description — TEXT
Link
- id — BIGINT
- name — VARCHAR(255)
- description — TEXT
- link_url — VARCHAR(255)
- category_id — BIGINT
- delete_tf — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — INT
buddy
- id — bigint(20) — Primary key — NOT NULL — 버디ID
- name — varchar(255) — 버디명
- creator_id — bigint(20) — NOT NULL — 생성자ID
- created_at — timestamp — 생성일시
- updated_at — timestamp — 수정일시
buddyuser
- id — bigint(20) — Primary key — NOT NULL — 버디회원ID
- user_id — bigint(20) — NOT NULL — 회원ID
- buddy_id — bigint(20) — Foreign key → buddy.id — NOT NULL — 버디ID
- alert_tf — bit(1) — NOT NULL — 알림여부
- pin_tf — bit(1) — NOT NULL — 고정여부
- accept_tf — bit(1) — NOT NULL — 초대수락여부
- accept_dt — timestamp — 초대수락일
- created_at — timestamp — 생성일시
- updated_at — timestamp — 수정일시