rollcall

Tables (5)

Organization (조직)

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • intro (Field2) — varchar(300)

attendance (출석)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • date (Field) — date
  • start_time (Field2) — time
  • total (Field3) — int
  • status (Field4) — varchar(20)

inout (Untitled3)

  • id (Key2) — bigint — Primary key — NOT NULL
  • attendance_id (Key) — bigint — Foreign key → attendance.id — NOT NULL
  • start_time (Field) — time
  • end_time (Field2) — time

member (사용자)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_num (Field) — bigint
  • nickname (Field2) — varchar(50)
  • password (Field3) — varchar(255)
  • email (Field4) — varchar(100)
  • phone (Field5) — varchar(50)
  • gender (Field6) — varchar(10)

or_people (조직에 속한 사람들)

  • id (Key) — bigint — Primary key — NOT NULL
  • organization_id (PK) — bigint — Foreign key → Organization.id — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL