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)