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