EntityPratice

Tables (26)

Address (주소)

  • Id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varchar

Board2 (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → Member2.id — NOT NULL
  • title (Field) — varchar
  • contents (Field2) — longtext
  • created_at (Field3) — datetime
  • update_at (Field4) — datetime

Build (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (varchar) — varcahr

Build (Untitled3)

  • id (Key) — PK — Primary key — NOT NULL
  • person_list (Key22) — Foreign key → Person.build_id — NOT NULL
  • Field — varcahr

Build (건물)

  • id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varchar

Build2 (건물2)

  • Id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varcahr

Company (회사)

  • Key — Primary key — NOT NULL
  • name (Field) — varchar

Delivery (배달)

  • id (Key) — Long — Primary key — NOT NULL
  • address (Field) — varchar

Item (품목)

  • id (Key) — Long — Primary key — NOT NULL
  • orderItems (Key22) — List(1:N) — Foreign key → Orders.member_id — NOT NULL
  • name (Field) — varcahr

Language (언어)

  • id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varchar

Member (회원)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varchar

Member2 (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varcahr
  • age (Field2) — Integer
  • password (Field3) — varchar
  • created_at (Field5) — datetime
  • update_at (Field6) — datetime

OrderItem (주문품목)

  • id (Key) — Long — Primary key — NOT NULL
  • Item_id (Key2) — FK — Foreign key → Item.id — NOT NULL
  • Order_id (Key3) — FK — Foreign key → Orders.id — NOT NULL
  • orderPrice (Field) — Integer
  • count (Field2) — Integer

Orders (주문)

  • id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — FK — Foreign key → Member.id — NOT NULL
  • delibvery_list (Key3) — Long — Foreign key → Delivery.id — NOT NULL
  • orderDate (Field) — Datetime

Person (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • build_id (Key2) — Long — Foreign key → Build.id — NOT NULL
  • name (Field2) — varchar

Person (사람4)

  • id (Key) — PK — Primary key — NOT NULL
  • company_id (Key2) — BigInt — Foreign key → Company.Key — NOT NULL
  • name (Field) — varcahr

Person (사람3)

  • id (Key) — PK — Primary key — NOT NULL
  • name (Field) — varcahr

Person (사람2)

  • Id (Key) — PK — Primary key — NOT NULL
  • address_Id (Key2) — FK(bigint) — Foreign key → Address.Id — NOT NULL
  • build_id (Key3) — FK(bigint) — Foreign key → Build2.Id — NOT NULL
  • name (Field) — varcahr

Person (사람)

  • Id (Key) — PK — Primary key — NOT NULL
  • build_id (Key2) — FK — Foreign key → Build.id — NOT NULL
  • name (Field) — varcahr

Person (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • build_id (Key2) — Long — Foreign key → Build.id — NOT NULL
  • name (Field) — varcahr

PersonLanguage (중간테이블)

  • id (Key3) — PK — Primary key — NOT NULL
  • language_id (Key2) — FK — Foreign key → Language.id — NOT NULL
  • person_id (Key) — FK — Foreign key → Person.id — NOT NULL
  • level (Field) — BIGINT
  • licence (Field2) — VARCHAR

ProductImage (제품이미지)

  • filename (Field) — varcahr(255)
  • ord (Field2) — BigInt

Todo (할일)

  • tno (Key) — auto_increment — Primary key — NOT NULL
  • title (Field) — varchar(500)
  • content (Field2) — varchar(255)
  • complete (Field3) — boolean
  • dueDate (Field4) — LocalDate

tdl_product (제품)

  • tno (Key) — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • price (Field2) — BigInt
  • delFlag (Field3) — boolena
  • pdesc (Field4) — varcahr(255)

사람회사 (FetchJoin)

  • Key — Primary key — NOT NULL
  • company_id (Key2) — BigInt — Foreign key → 사람회사.Key — NOT NULL
  • name (Field) — varcahr
  • Field3

사람회사 (FetchJoin2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → 사람회사.Key — NOT NULL
  • name (Field) — varcahr
  • Field3