Viên ngọc phương Đông

## 📦 Table: `tbl_static_data`

**Module:** `configuration`  
**Schema:** `public`  
**Purpose:** Stores static templates and configuration data used across the application.  
**Created By:** Mahendran T  
**Created On:** 2025-07-31  
**Last Modified:** 2025-07-31

---

## 🧩 Columns

| Column Name | Data Type   | Nullable | Default | Description                                      |
|-------------|------------|----------|---------|--------------------------------------------------|
| `id`        | SERIAL     | NO       | auto-increment | Primary key                               |
| `template`  | MEDIUMTEXT | YES      | NULL    | Template content (HTML, JSON, or text snippet)  |
| `name`      | VARCHAR(100)| YES     | NULL    | Name of the static data template                |

---

## 🗂️ Constraints & Indexes

* **Primary Key:** `id`  
* **Indexes:**  
  * `tbl_static_data_pkey` on `id` (UNIQUE, BTREE)  
  * Consider unique index on `name` to prevent duplicate templates

---

## 🔗 Relationships

* This table does not currently define explicit foreign key relationships.  
* Can be referenced by other modules needing template data (e.g., email templates, system messages).

---

## 🧬 ER Diagram (optional)

```dbml
Table tbl_static_data {
  id serial [pk]
  template mediumtext
  name varchar(100)
}
```

---

## 🛠️ Sample SQL

```sql
CREATE TABLE tbl_static_data (
    id SERIAL PRIMARY KEY,
    template MEDIUMTEXT DEFAULT NULL,
    name VARCHAR(100) DEFAULT NULL
);
```

---

## 🕓 Change History

| Date       | Author      | Change Description          |
| ---------- | ----------- | --------------------------- |
| 2025-07-31 | Mahendran | Initial documentation draft |