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