ARchive ERD

https://github.com/tukcomCD2024/DroidBlossom

Tables (16)

address

  • id — BIGINT — Primary key — NOT NULL
  • city — VARCHAR(100) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • zip_code — VARCHAR(20) — NOT NULL

capsule

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • address_id — BIGINT — Foreign key → address.id — NOT NULL
  • capsule_skin_id — BIGINT — Foreign key → capsule_skin.id — NOT NULL
  • group_id — BIGINT — Foreign key → group.id
  • due_date — TIMESTAMP
  • longitude — DECIMAL(11, 8) — NOT NULL
  • latitude — DECIMAL(11, 8) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_opened — BOOLEAN — NOT NULL
  • type — ENUM — NOT NULL

capsule_skin

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • skin_name — VARCHAR(50) — NOT NULL
  • size — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

friend_request

  • id — BIGINT — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → member.id — NOT NULL
  • friend_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

group

  • id — BIGINT — Primary key
  • group_name — VARCHAR(100) — NOT NULL
  • group_description — VARCHAR(255) — NOT NULL
  • group_profile_url — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

group_capsule_open

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • capsule_id — BIGINT — Foreign key → capsule.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

group_request

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • group_id — BIGINT — Foreign key → group.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

history

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

history_image

  • id — BIGINT — Primary key — NOT NULL
  • history_id — BIGINT — Foreign key → history.id — NOT NULL
  • image_id — BIGINT — Foreign key → image.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

image

  • id — BIGINT — Primary key — NOT NULL
  • capsule_id — BIGINT — Foreign key → capsule.id
  • image_url — VARCHAR(255) — NOT NULL
  • size — BIGINT — NOT NULL
  • image_name — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • phone — VARCHAR(20)
  • profile_url — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • oauth2_provider — VARCHAR(50) — NOT NULL
  • notification_enabled — BOOLEAN — NOT NULL
  • email — VARCHAR(255)
  • fcm_token — VARCHAR(255)
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_verified — BOOLEAN — NOT NULL

member_friend

  • id — BIGINT — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → member.id — NOT NULL
  • friend_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

member_group

  • id — BIGINT — Primary key
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • group_id — BIGINT — Foreign key → group.id — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • notification_category_id — BIGINT — Foreign key → notification_category.id — NOT NULL
  • text — TEXT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

notification_category

  • id — BIGINT — Primary key — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL
  • category_description — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

video

  • id — BIGINT — Primary key — NOT NULL
  • capsule_id — BIGINT — Foreign key → capsule.id
  • video_url — VARCHAR(255) — NOT NULL
  • size — INT — NOT NULL
  • video_name — VARCHAR(255) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL