udumeoli
Tables (8)
image
- id — NUMBER(19) — Primary key — NOT NULL
- original_url — VARCHAR2(512) — NOT NULL
- thumbnail_url — VARCHAR2(512)
- uploader_id — NUMBER(19) — Foreign key → service_user.id
- status — VARCHAR2(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
party
- id — NUMBER(19) — Primary key — NOT NULL
- party_name — VARCHAR2(100) — NOT NULL
- invite_code — VARCHAR2(12) — NOT NULL
- owner_id — NUMBER(19) — Foreign key → service_user.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
party_member
- id — NUMBER(19) — Primary key — NOT NULL
- party_id — NUMBER(19) — Foreign key → party.id — NOT NULL
- service_user_id — NUMBER(19) — Foreign key → service_user.id — NOT NULL
regions
- region_code — CHAR(5) — Primary key — NOT NULL
- region_name — VARCHAR2(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
service_user
- id — NUMBER(19) — Primary key — NOT NULL
- nickname — VARCHAR2(40) — NOT NULL
- profile_image_url — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
social_account
- id — NUMBER(19) — Primary key — NOT NULL
- service_user_id — NUMBER(19) — Foreign key → service_user.id — NOT NULL
- provider — VARCHAR2(20) — NOT NULL
- provider_user_id — VARCHAR2(150) — NOT NULL
- provider_email — VARCHAR2(320)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
trip_images
- id — NUMBER(19) — Primary key — NOT NULL
- trip_id — NUMBER(19) — Foreign key → trips.id — NOT NULL
- image_id — NUMBER(19) — Foreign key → image.id — NOT NULL
- image_date — DATE
- created_at — TIMESTAMP — NOT NULL
trips
- id — NUMBER(19) — Primary key — NOT NULL
- party_id — NUMBER(19) — Foreign key → party.id — NOT NULL
- region_code — CHAR(5) — Foreign key → regions.region_code — NOT NULL
- color — CHAR(7)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_by — NUMBER(19) — Foreign key → service_user.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL