d

Tables (18)

1

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — varchar(20) — NOT NULL
  • Field2 — timestamp — NOT NULL
  • Field3 — varchar(15) — NOT NULL
  • Field4 — varchar(20)
  • Field5 — varchar(15)
  • Field6 — varchar(50)
  • Field7 — varchar(20)
  • Field8 — timestamp — NOT NULL
  • Field9 — varchar(10) — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfCopyOfCopyOfCopyOfCopyOfUntitled6

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — timestamp — NOT NULL
  • Field3 — varchar(15) — NOT NULL
  • Field4 — varchar(15) — NOT NULL
  • Field5 — varchar(50) — NOT NULL
  • Field6 — timestamp — NOT NULL
  • Field7 — varchar(10) — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfCopyOfCopyOfCopyOfUntitled6

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — timestamp — NOT NULL
  • Field2 — timestamp
  • Field3 — varchar(50) — NOT NULL
  • Field4 — timestamp — NOT NULL
  • Field5 — varchar(10) — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfCopyOfCopyOfUntitled6

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — timestamp — NOT NULL
  • Field2 — timestamp
  • Field3 — varchar(15)
  • Field4 — varchar(50) — NOT NULL
  • Field5 — timestamp — NOT NULL
  • Field6 — varchar(10) — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfCopyOfUntitled4

  • Key — varchar(10) — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled4.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled4.Key2 — NOT NULL
  • Field — VARCHAR(255) — NOT NULL
  • Field2 — timestamp — NOT NULL
  • Field3 — varchar(10) — NOT NULL

CopyOfCopyOfUntitled6

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — VARCHAR(255) — NOT NULL
  • Field2 — timestamp — NOT NULL
  • Field3 — timestamp
  • Field4 — varchar(15) — NOT NULL
  • Field5 — varchar(20)
  • Field6 — varchar(50)
  • Field7 — timestamp — NOT NULL
  • Field8 — varchar(10) — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfUntitled4

  • Key — varchar(10) — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled.Key — NOT NULL
  • Field — VARCHAR(255) — NOT NULL
  • Field2 — timestamp — NOT NULL
  • Field3 — varchar(10) — NOT NULL
  • Field4 — varchar(50) — NOT NULL

CopyOfUntitled6

  • Key — int — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled5.Key — NOT NULL
  • Key22 — varchar(15) — Foreign key → Untitled5.Key2 — NOT NULL
  • Field — timestamp — NOT NULL
  • Field2 — varchar(10) — NOT NULL
  • Field3 — varchar(50)
  • Field4 — VARCHAR(255)
  • Field5 — varchar(50) — NOT NULL
  • Field6 — timestamp — NOT NULL
  • Field7 — varchar(10) — NOT NULL
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

CopyOfUntitled62

  • Key — int — Primary key — NOT NULL
  • Field — varchar(20) — NOT NULL
  • Field12 — double — NOT NULL
  • Field13 — double — NOT NULL
  • Field2 — varchar(10) — NOT NULL
  • Field3 — varchar(50)
  • Field4 — varchar(10)
  • Field5 — varchar(50) — NOT NULL
  • Field6 — varchar(10) — NOT NULL
  • Field7 — varchar(15) — NOT NULL
  • Field8 — varchar(10) — NOT NULL
  • Field9 — varchar(10) — NOT NULL
  • Field10 — timestamp — NOT NULL
  • Field11 — varchar(10) — NOT NULL

CopyOffile

  • file_seq — SERIAL — Primary key — NOT NULL
  • file_nm — VARCHAR(100) — NOT NULL
  • file_type — VARCHAR(20) — NOT NULL
  • url — VARCHAR(100) — NOT NULL — 경로
  • use_yn — CHAR(1) — NOT NULL
  • reg_dt — TIMESTAMP — NOT NULL
  • reg_user — VARCHAR(20) — NOT NULL
  • mod_dt — TIMESTAMP
  • mod_user — VARCHAR(20)

Untitled

  • Key — varchar(15) — Primary key — NOT NULL
  • Field — varchar(20) — NOT NULL
  • Field2 — varchar(10) — NOT NULL
  • Field3 — varchar(50)
  • Field4 — varchar(10)
  • Field5 — varchar(50) — NOT NULL
  • Field6 — varchar(10) — NOT NULL
  • Field7 — varchar(15) — NOT NULL
  • Field8 — varchar(10) — NOT NULL
  • Field9 — varchar(10) — NOT NULL
  • Field10 — timestamp — NOT NULL
  • Field11 — varchar(10) — NOT NULL
  • Field12 — timestamp
  • Field13 — varchar(10)
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq

Untitled2

  • Key — varchar(15) — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled.Key — NOT NULL
  • Field — varchar((20) — NOT NULL
  • Field12 — double — NOT NULL
  • Field13 — double — NOT NULL
  • Field2 — varchar(10) — NOT NULL
  • Field3 — varchar(50)
  • Field4 — varchar(10)
  • Field5 — varchar(50) — NOT NULL
  • Field6 — varchar(10) — NOT NULL
  • Field7 — varchar(15) — NOT NULL
  • Field8 — varchar(10) — NOT NULL
  • Field9 — varchar(10) — NOT NULL
  • Field10 — timastamp — NOT NULL
  • Field11 — varchar(10) — NOT NULL
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

Untitled3

  • Key3 — VARCHAR(255) — Primary key — NOT NULL
  • Key — varchar(15) — Foreign key → Untitled2.Key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled2.Key2 — NOT NULL
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq — NOT NULL
  • Field — varchar(10) — NOT NULL
  • Field2 — varchar(10)
  • Field3 — varchar(15) — NOT NULL
  • Field4 — varchar(15)
  • Field5 — varchar(50) — NOT NULL
  • Field6 — varchar(20)
  • Field7 — timestamp — NOT NULL
  • Field8 — varchar(10) — NOT NULL

Untitled4

  • Key — varchar(15) — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled.Key — NOT NULL
  • Field — varchar(10) — NOT NULL
  • Field2 — varchar(10)
  • Field3 — varchar(15) — NOT NULL
  • Field4 — VARCHAR(255) — NOT NULL
  • Field5 — varchar(50) — NOT NULL
  • Field6 — varchar(50) — NOT NULL
  • Field7 — timestamp — NOT NULL
  • Field8 — varchar(10) — NOT NULL
  • Field9 — timestamp
  • Field10 — varchar(10)
  • file_seq — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq2 — SERIAL — Foreign key → CopyOffile.file_seq
  • file_seq3 — SERIAL — Foreign key → CopyOffile.file_seq

Untitled5

  • Key — varchar(15) — Primary key — NOT NULL
  • Key2 — varchar(15) — Foreign key → Untitled2.Key — NOT NULL
  • Field — VARCHAR(255) — NOT NULL
  • Field2 — VARCHAR(255) — NOT NULL
  • Field3 — timestamp — NOT NULL
  • Field4 — varchar(10) — NOT NULL
  • Field5 — timestamp
  • Field6 — varchar(10)
  • Field7 — VARCHAR(255) — NOT NULL
  • Field8 — varchar(10)
  • Field9 — timestamp

Untitled6

  • Key3 — varchar(15) — Primary key — NOT NULL
  • Field — VARCHAR(255) — NOT NULL — 변경여부가 Y 인경우에만 변경이력 테이블에서 정보를 가져옴
  • Field2 — timestamp — NOT NULL
  • Field3 — varchar(10) — NOT NULL

Untitled7

  • Key — VARCHAR(255) — Primary key — NOT NULL

Untitled8

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Key2 — VARCHAR(255) — Foreign key → Untitled8.Key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)