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