Skip to content

Instantly share code, notes, and snippets.

@KevinStrong

KevinStrong/3_join.yaml

Last active February 15, 2022 00:39
Show Gist options
  • Save KevinStrong/4fe413e30ce4fd45a47eac3a334bb85b to your computer and use it in GitHub Desktop.
Save KevinStrong/4fe413e30ce4fd45a47eac3a334bb85b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. KevinStrong revised this gist Feb 15, 2022. 1 changed file with 5 additions and 4 deletions.
    9 changes: 5 additions & 4 deletions 3_join.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -12,17 +12,18 @@ databaseChangeLog:
    name: kiosk_id
    type: BIGINT
    constraints:
    primaryKey: true
    primaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_kiosk_id
    references: checkin.kiosks(id)
    - column:
    name: event_id
    type: BIGINT
    constraints:
    primaryKey: true
    primaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_event_id
    references: checkin.events(id)
    - addPrimaryKey:
    schemaName: checkin
    tableName: kiosk_events
    constraintName: pk_kiosk_events
    columnNames: kiosk_id, event_id
  2. KevinStrong revised this gist Jan 7, 2022. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions 3_join.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -12,8 +12,8 @@ databaseChangeLog:
    name: kiosk_id
    type: BIGINT
    constraints:
    pimaryKey: true
    pimaryKeyName: pk_kiosk_events
    primaryKey: true
    primaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_kiosk_id
    references: checkin.kiosks(id)
    @@ -22,7 +22,7 @@ databaseChangeLog:
    type: BIGINT
    constraints:
    primaryKey: true
    pimaryKeyName: pk_kiosk_events
    primaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_event_id
    references: checkin.events(id)
  3. KevinStrong created this gist Nov 8, 2021.
    28 changes: 28 additions & 0 deletions 3_join.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,28 @@
    databaseChangeLog:
    - changeSet:
    - id: 3-create-join-table
    author: [email protected]
    changes:
    - createTable:
    tableName: kiosk_events
    remarks: A join table between kiosks and events
    schemaName: checkin
    columns:
    - column:
    name: kiosk_id
    type: BIGINT
    constraints:
    pimaryKey: true
    pimaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_kiosk_id
    references: checkin.kiosks(id)
    - column:
    name: event_id
    type: BIGINT
    constraints:
    primaryKey: true
    pimaryKeyName: pk_kiosk_events
    nullable: false
    foreignKeyName: fk_event_id
    references: checkin.events(id)