테스트

테이블 (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