테스트
테이블 (12)
Bank
- B_NO — INT — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR(20) — NOT NULL
- B_NAME — VARCHAR(30) — NOT NULL
- B_AMOUNT — INT
- B_DATE — DATE
- INDEX — fk_BANK_MEMBER1_idx
Board
- B_IDX — INT — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR(20) — 기본 키 — NOT NULL
- SUBJECT — VARCHAR(50)
- CONTENT — VARCHAR(5000)
- HIT — INT
- POST_DATE — DATETIME
- FILENAME — VARCHAR(100)
- FILESIZE — INT
- DOWN — INT
- REF — INT
- DEPTH — INT
- REORDER — INT
- INDEX — fk_BOARD_MEMBER1_idx
Comment
- undefined_IDX — INT — NOT NULL
- BOARD_IDX — INT — NOT NULL
- MEMBER_ID — VARCHAR(20) — NOT NULL
- undefined — VARCHAR(3000)
- INDEX — fk_undefined_BOARD1_idx
Detail
- DE_NO — INT — 기본 키 — NOT NULL
- OUT_NO — INT — 기본 키 — NOT NULL
- DE_NAME — VARCHAR(60) — NOT NULL
- INDEX — fk_SEPARATION_OUTCOME1_idx
Goal
- G_NO — INT — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR(20) — NOT NULL
- G_AMOUNT — INT
- G_DREAM — VARCHAR(45)
- G_DATE — DATE
- INDEX — fk_GOAL_MEMBER1_idx
GoalDetail
- GD_NO — INT — 기본 키 — NOT NULL
- G_NO — INT — 기본 키 — NOT NULL
- GD_CHECK — INT
- GD_DATE — DATE
- INDEX — fk_GOALDETAIL_GOAL1_idx
Good
- GOOD_NO — INT — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR(20) — NOT NULL
- GD_NO — INT — NOT NULL
- G_NO — INT — NOT NULL
- GOOD_COUNT — INT
- INDEX — fk_GOOD_GOALDETAIL1_idx
- INDEX — fk_GOOD_MEMBER1_idx
Income
- IN_NO — INT — 기본 키 — NOT NULL
- B_NO — INT — NOT NULL
- IN_DATE — DATE
- IN_AMOUNT — INT
- IN_PEOPLE — VARCHAR(20)
- INDEX — fk_INCOME_BANK1_idx
Member
- ID — VARCHAR(20) — 기본 키 — NOT NULL
- R_NO — INT — NOT NULL
- PW — VARCHAR(20) — NOT NULL
- NAME — VARCHAR(30)
- AGE — INT
- INDEX — fk_MEMBER_REGION1_idx
Outcome
- OUT_NO — INT — 기본 키 — NOT NULL
- B_NO — INT — NOT NULL
- OUT_DATE — DATE
- OUT_AMOUNT — INT
- OUT_DETAIL — VARCHAR(45)
- INDEX — fk_OUTCOME_BANK1_idx
Region
- R_NO — INT — 기본 키 — NOT NULL
- R_NAME — VARCHAR(45) — NOT NULL
Victory
- V_NO — INT — 기본 키 — NOT NULL
- MEMBER_ID — VARCHAR(20) — 기본 키 — NOT NULL
- V_DATE — DATE
- INDEX — fk_VICTORY_MEMBER1_idx