DeSSaCManageProgram
Tables (15)
EducationRequest (Untitled5)
- id — Primary key — NOT NULL
- source_id — BIGINT — Foreign key → application_source.id — NOT NULL
- school_id (Key2) — Foreign key → school.id — NOT NULL
User (user)
- id — BIGINT — Primary key — NOT NULL
- name
- birth
- phone
- created_at
- updated_at
- application_source_id (id2) — BIGINT — Foreign key → application_source.id — NOT NULL
address (Untitled4)
- id — Primary key — NOT NULL
- sido
- detail
- created_at
- updated_at
application_profile (Untitled6)
- id (Key) — Primary key — NOT NULL
application_source (Untitled3)
- id — BIGINT — Primary key — NOT NULL
- source_type
- name
- created_at
kit (Untitled8)
- id (Key) — Primary key — NOT NULL
- name (Field)
permission
- id — Primary key — NOT NULL
- name
- discription
program (Untitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
- link (Field3)
- lms_id (Field2)
- social_con_type (Field4)
program_kit_rule (Untitled9)
- id (Key) — Primary key — NOT NULL
- program_id (Key2) — Foreign key → program.id — NOT NULL
- kit_id (Key3) — Foreign key → kit.id — NOT NULL
- cnt_per_student (Field)
role
- id — Primary key — NOT NULL
- name
role_permission (Untitled)
- role_id — Foreign key → role.id — NOT NULL
- permission_id — Foreign key → permission.id — NOT NULL
school (Untitled2)
- id (Key) — Primary key — NOT NULL
- address_id (id) — Foreign key → address.id — NOT NULL
- name
- social_con_type
stock (Untitled10)
- id (Key) — Primary key — NOT NULL
- kit_id (Key2) — Foreign key → kit.id — NOT NULL
- cnt (Field)
- status (Field4)
- created_at (Field2)
- updated_at (Field3)
stock_history (Untitled11)
- id (Key2) — Primary key — NOT NULL
- stock)id (Key) — Foreign key → stock.id — NOT NULL
- cnt (Field)
- status (Field2)
- created_at (Field3)
user_role
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- role_id — Foreign key → role.id — NOT NULL