data
Tables (9)
authority (권한 테이블)
- id (Key2) — Integer — Primary key — NOT NULL
- name — String
data_user (Untitled)
- user_id (Key) — Integer — Primary key — NOT NULL
- email (Field) — String
- nickname (username?) — String
- password (Field3) — String
- authority_id (Key2) — Integer — Foreign key → authority.id — NOT NULL
image_data (Untitled4)
- id (Key) — Integer — Primary key — NOT NULL
- file_path (Field) — String
- create_date (Field2) — Date
- image_format_id (Key2) — Integer — Foreign key → image_format.id — NOT NULL
- site_id (Key3) — Integer — Foreign key → site.site_id — NOT NULL
image_format (Untitled2)
- id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
job_data (Untitled8)
- id (Key) — Integer — Primary key — NOT NULL
- image_data_id (Key2) — Integer — Foreign key → image_data.id — NOT NULL
- label_data_id (Key3) — Integer — Foreign key → label_data.id — NOT NULL
- job_id (Key4) — Integer — Foreign key → job_format.id — NOT NULL
job_format (Untitled7)
- id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
- image_format_id (Key2) — Integer — Foreign key → image_format.id — NOT NULL
- label_format_id (Key3) — Integer — Foreign key → label_format.id — NOT NULL
label_data (Untitled5)
- id (Key) — Integer — Primary key — NOT NULL
- file_path (Field) — String
- create_date (Field2) — Date
- last_modified_date (Field3) — Date
- user_id (Key2) — Integer — Foreign key → data_user.user_id — NOT NULL
label_format (Untitled6)
- id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
- file_extension (Field2) — String
site (고객사 테이블)
- site_id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String