DeVue

Tables (3)

Group (그룹)

  • GROUP_INDX (Key) — LONG — Primary key — NOT NULL
  • GROUP_NAME (Field) — VARCHAR(30)
  • GROUP_PW (Field2) — VARCHAR(30)
  • USED_YN (Field3) — VARCHAR(2)
  • GROUP_IMG (Field4) — VARCHAR(100)
  • GROUP_DESC (Field5) — VARCHAR(500)
  • USER_INDX (Key2) — LONG — Foreign key → Member.USER_INDX — NOT NULL

Member (유저 Table)

  • USER_INDX (Key) — LONG — Primary key — NOT NULL
  • USER_ID (Field) — VARCHAR(30)
  • USER_PW (Field2) — VARCHAR(30)
  • USER_NAME (Field3) — VARCHAR(20)
  • USER_SEX (Field4) — boolean
  • USER_GRADE (Field5) — Long — S - Super A - Admin M - Member X - Stop Member D - Delete User
  • CELL_PHONE (Field6) — VARCHAR(20)
  • USER_NATION (Field7) — VARCHAR(30)

POST (게시글)