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)