2nd-java

Tables (3)

application (Untitled)

  • id (Key) — Primary key — NOT NULL
  • reason (Field) — String
  • after (Field2) — String
  • applicationstatus (Field3) — enum
  • count (Field4) — int
  • member_id (Key2) — long — Foreign key → member.id — NOT NULL
  • lesson_id (Key3) — long — Foreign key → lesson.id — NOT NULL

lesson (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • lessonname (Field) — String
  • date (Field2) — String
  • courseperiod (Field3) — String

member (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — string
  • password (Field2) — string
  • memberstatus (Field3) — enum
  • number (Field4) — String