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