ㅇ

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

Favorite

    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 — 수정일시