2024_2_db_ex2-1

Tables (4)

Untitled (활동)

  • Key (활동코드) — char(10) — Primary key — NOT NULL
  • Field (활동명) — char(20)
  • Field (활동설명) — text

Untitled (클래스)

  • Key (클래스 아이디) — char)10) — Primary key — NOT NULL
  • Key (활동코드) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (클래스이름) — char(10)
  • Field (클래스시간) — char(20)
  • Field (클래스사이즈(정원)) — int(3)
  • Field (클래스레벨) — char(4)
  • Field (클래스강사) — char(10)
  • Field (클래스가격) — int(10)
  • Field (클래스위치) — char(20)
  • Field (년도) — char(4)
  • Field (월) — char(2)

Untitled (회원)

  • Key (회원코드) — char(10) — Primary key — NOT NULL
  • Field (회원이름) — char(20)
  • Field (회원주소) — char(50)
  • Field (회원전화번호) — char(11)
  • Field (회원생년월일) — date
  • Field (성별) — char(1)

Untitled (등록)

  • Key (회원코드) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (클래스 아이디) — char)10) — Foreign key → Untitled.Key — NOT NULL
  • Key (활동코드) — char(10) — Foreign key → Untitled.Key — NOT NULL