WEVI(SG)

Tables (15)

Categories

  • category_id — INT — Primary key — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL
  • category_name — VARCHAR(50) — NOT NULL
  • category_created_at — TIMESTAMP
  • category_updated_at — TIMESTAMP

Contracts

  • Key — INT — Primary key — NOT NULL
  • schedule_id — BIGINT — NOT NULL
  • total_amount — DECIMAL(15,2) — NOT NULL
  • details — TEXT
  • status — ENUM('ACTIVE', 'CANCELED') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

CoupleRequests

  • couplerequest_id — INT — Primary key — NOT NULL
  • couplerequest_sender_id — INT — NOT NULL
  • couplerequest_receiver_id — INT — NOT NULL

Couples

  • id — INT — Primary key — NOT NULL
  • user_1_id — BIGINT — NOT NULL
  • user_2_id — BIGINT — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'DECLINED') — NOT NULL
  • created_at — TIMESTAMP

MediaFiles

  • Key — INT — Primary key — NOT NULL
  • type — ENUM('IMAGE', 'VIDEO') — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

MiddleProcessTemplates

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

MiddleProcesses

  • id — INT — Primary key — NOT NULL
  • schedule_id — BIGINT — NOT NULL
  • template_id — BIGINT — NOT NULL
  • status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Notifications

  • id — INT — Primary key — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

Reviews

  • id — INT — Primary key — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Schedules

  • schedule_id — INT — Primary key — NOT NULL
  • schedule_title — VARCHAR(255) — NOT NULL
  • schedule_start_date — DATETIME — NOT NULL
  • schedule_end_date — DATETIME — NOT NULL
  • schedule_details — TEXT
  • schedule_status — ENUM('PENDING', 'CONFIRMED', 'CANCELED') — NOT NULL
  • schedule_created_at — TIMESTAMP
  • schedule_updated_at — TIMESTAMP
  • schedule_iscalender — int

Schedules_Vendor

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • details — TEXT
  • status — ENUM('PENDING', 'CONFIRMED', 'CANCELED') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User_Schedules

  • schedule_user_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • schedule_id — INT — NOT NULL

Users

  • user_id — INT — Primary key — NOT NULL
  • user_email — VARCHAR(255) — NOT NULL — UNIQUE
  • user_nickname — VARCHAR(100) — UNIQUE
  • user_name — VARCHAR(100) — NOT NULL
  • user_password — VARCHAR(255) — NOT NULL
  • user_phone — VARCHAR(20) — NOT NULL
  • user_address — VARCHAR(255)
  • user_created_at — TIMESTAMP
  • user_updated_at — TIMESTAMP

Vendor-Schedule

  • id — INT — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • id2 — INT — NOT NULL
  • schedule_id — INT — NOT NULL

Vendors

  • id — INT — Primary key — NOT NULL
  • vendor_email — VARCHAR(255)
  • vendor_password — VARCHAR(255)
  • vendor_ownername — VARCHAR(100)
  • vendor_owner_phone — VARCHAR(20)
  • vendor_name — VARCHAR(100)
  • vendor_phone — VARCHAR(20) — NOT NULL
  • vendor_address — VARCHAR(255) — NOT NULL
  • vendor_registration_number — VARCHAR(50) — NOT NULL
  • vendor_created_at — TIMESTAMP
  • vendor_updated_at — TIMESTAMP
  • category_id — INT — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL